(Matteo Lorini) Why index and statistics are not always used on a computed column. In this tip we look at how SQL Server generates a query plan based on a computed column and different methods to have it use the index.
Other News
Ten Worst Things to Do in a Database
Ten Worst Things to Do in a Database I decided to do a series on the Ten Worst Things to do in a Database. I started to list practices I dislike when working with a database. It didn’t take long until I had more than Ten. Now I have to prioritize…and I’m sure I missed a few good contenders. Already […]
Consuming JSON and XML Webservices from an HTML Page using jQuery
(Rajesh Toleti) My previous article http://aspalliance.com/713, explains about consuming web services from HTML pages, but it is restricted to IE only. I would like to explain a method which overcomes that and works in all major browsers. This time I want to show how to consume both JSON and XML dat
Invoking Stored Procedures and Functions with Named Variable Parameters
(Andrejus Baranovskis) This example will explain briefly, how to use named variable parameters for PL/SQL calls. As for example, this simple PL/SQL procedure with IN and OUT parameter will be used:
The DB2Night Show #50: Put on the Boxing Gloves, DB2 LUW vs Oracle, Part 1
(Scott Hayes) It’s a KNOCK OUT! Special guests from Triton Consulting and IBM Canada presented findings from their DB2 LUW versus Oracle Usability study. While you might expect some bias, the methods deployed for the study seem rather objective and mathematically quantified.
Drop table performance
(Vadim Tkachenko) There have been recent discussions about DROP TABLE performance in InnoDB.
ASP.NET Rating Control
(taihip) There are many free rating controls on the internet, but I didn’t find any control which fits these features:
SQL Server Agent Proxies
(Manjunath C Bhat) SQL Server Agent Proxies are very helpful in executing some jobs. I had came across a situation where in I was scratching my head so as to how to accomplish a task which I wanted to run as SQL server Agent Job. First let me give some brief description about proxies.
XML sessions at IDUG North America 2011
(Matthias Nicola) Now it’s only one week until the International DB2 User Group (IDUG) holds their annual North American conference, this time in Anaheim, CA, on May 2 – 6. The conference agenda looks terrific, with more than 100 technical sessions, full-day seminars, panel discussions, vendor solut
Why database not startup automatic 11gR2 Grid Infrastructure?
(Surachart Opun) I have used Database on Grid Infrastructure for a Stand-Alone Server. I stopped database and then rebooted server for something. After rebooted… Database not startup automatic?