A sneak preview of my SQLPASS sessions: I wrote about optimizing Lazy Spool on the PASS blog, and here are the first two paragraphs with a link to the rest.
Do Index Reorganization Update Statistics? – Interview Question of the Week #196
Question: Do Index Reorganization Update Statistics?
Answer: No. Index Reorganization does not update Statistics of your database.
How to Find Queries Using an Index From SQL Server Plan Cache? – Interview Question of the Week #195
Before I dropped an unused index, my client’s CEO wanted proof. Here is how to find queries using an index from the SQL Server plan cache.
Index Key Size Limits: 900 and 1,700 Bytes Explained
Check index key size against the 900-byte clustered and 1,700-byte nonclustered limits, then narrow keys without losing query semantics.
SQL SERVER – Rebuild Index Job Failed – Error: 9002 – The Transaction Log for Database ‘PinalDB’ is Full Due to ‘LOG_BACKUP’
A rebuild index job kept failing with error 9002: The transaction log for database ‘PinalDB’ is full due to ‘LOG_BACKUP’. Here is how I found the real cause.
Blind Index: Searching an Encrypted Column Without Decrypting
Encrypted emails cannot be searched, so store a keyed digest beside them. A hands-on demo of how it works, what it leaks and how rotation hurts.
How to Find Cardinality or Uniqueness for any Column? – Interview Question of the Week #177
What is Cardinality, and how do you find it for a column? This simple script shows the percentage of unique values, using an AdventureWorks table.