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.
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.
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.
SQL Authority News – Brent Ozar Unlimited Office Hours 2018/4/4 – Fun Experience
I joined Brent, Richie and Tara for Brent Ozar Unlimited office hours and answered live questions, from replication latency to disk space. Here is the list.
Practical Real World Performance Tuning – Frequently Asked Questions
Seats for Practical Real World Performance Tuning with Brent Ozar are nearly gone. Here are answers to the questions I keep getting by email about the course.