Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – Interesting Observation about Order of Resultset without ORDER BY

November 24, 2008

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Today I observed very interesting little thing about SQL Server and I felt that I should share this with my readers. I ran following two queries and found that I am getting different result-set. When I carefully observed I found that actually the result was same but order of the…

SQL SERVER – 2008 – Download and Install Sample Database AdventureWorks 2008

November 23, 2008

Pinal Dave

SQL

SQL Download, SQL Sample Database, SQL Server

The following sample database is currently available for Microsoft SQL Server 2005 and Microsoft SQL Server 2008:

SQL SERVER – Simple Use of Cursor to Print All Stored Procedures of Database Including Schema

November 22, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Scripts, SQL Stored Procedure

I love active participation from my readers. Just a day ago I wrote article about SQL SERVER – Simple Use of Cursor to Print All Stored Procedures of Database. I just received comment from Jerry Hung who have improved on previously written article of generating text of Stored Procedure. DECLARE…

SQLAuthority News – SQL Server White Paper: SQL Server 2008 Compliance Guide

November 21, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Software Development, SQL Download, SQL White Papers

Note: Download White Paper by Microsoft Organizations across the globe are being inundated with regulatory requirements. They also have a strong need to better manage their IT systems to ensure they are operating efficiently and staying secure. Microsoft is often asked to provide guidance and technology to assist organizations struggling…

SQL SERVER – Simple Use of Cursor to Print All Stored Procedures of Database

November 20, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Cursor, SQL Scripts, SQL Stored Procedure

SQLAuthority Blog reader YordanGeorgiev has submitted very interesting SP, which uses cursor to generate text of all the Stored Procedure of current Database. This task can be done many ways, however, this is also interesting method. USE AdventureWorks GO DECLARE @procName VARCHAR(100) DECLARE @getprocName CURSOR SET @getprocName = CURSOR FOR SELECT s.name…

SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Group Photo

November 19, 2008

Pinal Dave

SQLAuthority News

DBA, MVP, SQL Server, SQLAuthority Author Visit

MVP Open day 2008 is one of the best event happened so far. I have previously written about this event in detail on this blog.

SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Day 3

November 18, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, MVP, Openday, SQLAuthority Author Visit

Yesterday was our last day at South Asia MVP Open Day. For three days continuously we are having great time along with fellow MVP. Every MVP was having great time because the way whole event was planned. We had plenty of time for networking as well lots of interesting sessions…