Feeds:
Posts
Comments

Archive for November, 2009

SQL Authority News – Training MS SQL Server 2005/2008 Query Optimization And Performance Tuning

Posted in Pinal Dave, SQL, SQL Authority, SQL Index, SQL Optimization, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, SQL Training, SQLAuthority News, T SQL, Technology on November 10, 2009 | 23 Comments »

This is very short note announcing details about my course details for ‘MS SQL Server 2005/2008 Query Optimization And Performance Tuning‘. The course is scheduled to be delivered from 19th Nov, 2009 and 21st Nov, 2009 in Pune, India. This three day course is an intensive course designed to give attendees an in-depth look at [...]

Read Full Post »

SQL SERVER – Removing Key Lookup – Seek Predicate – Predicate – An Interesting Observation Related to Datatypes

Posted in Pinal Dave, SQL, SQL Authority, SQL Index, SQL Optimization, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on November 9, 2009 | 13 Comments »

Recently, I have been working on Query Optimization project. While working on it, I found the following interesting observation. This entire concept may appear very simple, but if you are working in the area of query optimization and server tuning, you will find such useful hints. Before we start, let us understand the difference between [...]

Read Full Post »

SQL SERVER – Stored Procedure are Compiled on First Run – SP taking Longer to Run First Time

Posted in Pinal Dave, SQL, SQL Authority, SQL Interview Questions and Answers, SQL Query, SQL Scripts, SQL Server, SQL Stored Procedure, SQL Tips and Tricks, T SQL, Technology, tagged on November 8, 2009 | 13 Comments »

During the PASS summit, one of the attendees asked me the following question. Why the Stored Procedure takes long time to run for first time? The reason for the same is because Stored Procedures are compiled when it runs first time. When I answered the same, he replied that Stored Procedures are pre-compiled, and this [...]

Read Full Post »

SQLAuthority News – Data Compression Strategy Capacity Planning and Best Practices

Posted in Pinal Dave, SQL, SQL Authority, SQL Data Storage, SQL Query, SQL Server, SQL Tips and Tricks, SQL White Papers, SQLAuthority News, T SQL, Technology, tagged on November 7, 2009 | Leave a Comment »

Data Compression: Strategy, Capacity Planning and Best Practices SQL Server Technical Article Writer: Sanjay Mishra Contributors: Marcel van der Holst, Peter Carlin, Sunil Agarwal Technical Reviewer: Stuart Ozer, Lindsey Allen, Juergen Thomas, Thomas Kejser, Burzin Patel, Prem Mehra, Joseph Sack, Jimmy May, Cameron Gardiner, Mike Ruthruff, Glenn Berry (SQL Server MVP), Paul S Randal (SQLskills.com), [...]

Read Full Post »

SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 4

Posted in MVP, PASS, Pinal Dave, SQL, SQL Authority, SQL PASS, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Author Visit, SQLAuthority News, T SQL, Technology on November 6, 2009 | 2 Comments »

Fourth day was awesome! I had scheduled nearly 8 meetings with different groups of people today. It was really great fun. Let us see the keypoints for the same. PASS President Wayne Snyder honored and thanked Kevin Kline for his 10 YEARS of service. Kevin then gets a well-deserved standing ovation from the entire audience. [...]

Read Full Post »

« Newer Posts - Older Posts »

Follow

Get every new post delivered to your Inbox.

Join 15,279 other followers