“What will be the order of the result set of a SELECT statement on clustered indexed table when the ORDER BY clause is not used?”
SQL SERVER – Actual Execution Plan vs. Estimated Execution Plan
I was recently invited to participate in big discussion on one of the online forum, the topic was Actual Execution Plan vs. Estimated Execution Plan. I refused to participate in that particular discussion as I have very simple but strong opinion about this topic. I always use Actual Execution Plan…
Read MoreSQL SERVER – 2005 – Explanation and Script for Online Index Operations – Create, Rebuild, Drop
SQL Server 2005 Enterprise Edition supports online index operations. Index operations are creating, rebuilding and dropping indexes. The question which I receive quite often – what is online operation? Is online operation is related to web, internet or local network? Online operation means when online operations are happening the database…
Read MoreSQL SERVER – Insert Data From One Table to Another Table – INSERT INTO SELECT – SELECT INTO TABLE
Following three questions are many times asked on this blog. How to insert data from one table to another table efficiently? How to insert data from one table using where condition to another table? How can I stop using cursor to move data from one table to another table? There…
Read MoreSQLAuthority News – Author Visit – Database Architecture and Implementation Discussion – New York, New Jersey Details
Last weekend I visited New York City (NY) and Edison (NJ) to attend database architecture meeting with a big environmental technology firm. It was very interesting to meet CEO and few of the lead database administrators. Lots of database related things were discussed. I will list few of the points…
Read MoreSQL SERVER – 2005 – SSMS – View/Send Query Results to Text/Grid/Files
Many times I have been asked how to change the result window from Text to Grid and vice versa. There are three different ways to do it. Method 1 : Key-Board Short Cut Results to Text – CTRL + T Results to Grid – CTRL + D Results to File…
Read MoreSQL SERVER – CASE Statement in ORDER BY Clause – ORDER BY using Variable
This article is as per request from Application Development Team Leader of my company. His team encountered code where application was preparing string for ORDER BY clause of SELECT statement. Application was passing this string as variable to Stored Procedure (SP) and SP was using EXEC to execute the SQL…
Read More