Indexing foreign keys can speed joins and parent deletes when child-side indexes are missing; learn how to find gaps and test write tradeoffs.
SQL SERVER – Finding Expensive Cached Query Statements with DMVs
Finding the Most Expensive Queries starts with choosing a resource measure. I use cached statistics as an investigation aid.
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.
Aggregate Before the Join: Shrinking Rows Early With GROUP BY
Aggregate before the join only when the grouping preserves the required customer result. This private lab checks NULLs, missing matches, duplicate dimensions, complete outputs, actual plans, and reads.
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%.