My basic script to find the most expensive queries running on SQL Server using DMVs, the one I use in my query tuning consulting projects.
SQL SERVER – Four Posts on Removing the Bookmark Lookup – Key Lookup
Many developers meet a bookmark lookup or key lookup every day without knowing what to do. Here are four posts on removing the bookmark lookup from plans.
SQL SERVER – Size of Index Table for Each Index – Solution 3 – Powershell Index Size
Laerte Junior fixed my Powershell setup remotely in minutes and sent solution 3 to my puzzle on the size of each index. Here is his Powershell Index Size answer.
SQL SERVER – Size of Index Table for Each Index – Solution 2
A second solution to my size of index table puzzle: Rama Mathanmohan’s query sums used pages from sys.allocation_units to give each index size in KB.
SQL SERVER – GUID vs INT – Your Opinion
GUID vs INT as a primary key or clustered index: I list one advantage and one disadvantage of each and ask you to add yours in the comments.
SQL SERVER – Update Statistics are Sampled By Default
A reader asked if statistics are sampled by default. They are, and a one million row test table proves it. You can set the rate up to 100%.
SQL SERVER – When Are Statistics Updated – What Triggers Statistics to Update
When are statistics updated in SQL Server, and what triggers it? I compared the algorithms in many documents and share the most common rule. Tell me if it holds.