This is very short note announcing details about my course details for ‘Training MS SQL Server 2005/2008 Query Optimization And Performance Tuning’.
SQL SERVER – Removing Key Lookup – Seek Predicate – Predicate – An Interesting Observation Related to Datatypes
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…
Read MoreSQL SERVER – Stored Procedure are Compiled on First Run – SP taking Longer to Run First Time
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…
Read MoreSQLAuthority News – Data Compression Strategy Capacity Planning and Best Practices
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…
Read MoreSQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 4
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…
Read MoreSQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 3
The third day at SQL PASS Summit was education + entertainment day for me. During the last 10 days, I woke up at 4:00 AM regularly. However, as I had way too much fun yesterday at various parties earlier, I did not get up till 7:30 AM. By the time…
Read More
SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 2
The second day of PASS started with very engaging and it started with an original game invented by Stuart Ainsworth. This game involves finding twitter people in real life. As I was not one of the square in bingo, I had decided to participate in game myself and try to…
Read More