A second run is faster, but SQL Server did not remember your answer. A tiny demo shows what really gets reused: pages and plans.
SQL SERVER – How to Ignore Columnstore Index Usage in Query
A reader’s query ran slower after adding a nonclustered columnstore index. Here is how to ignore columnstore index usage for just that one query.
SQL SERVER – Fundamentals of Columnstore Index
Row store vs column store, explained simply. A Columnstore Index can make searches much faster, but it is not for every table. Learn where each one fits.
Searching Every Error Log for Slow I/O Warnings
The warning you need may be in an archived log. Here is a short loop that searches every retained error log and tells you which ones it could not read.
SQL Server Wait Stats: eBook to Download on Kindle and My Answer to Free PDF Requests
SQL Server Wait Stats was my first book experiment. Here is how I answered readers who asked for a free PDF, and what the Kindle offer looked like in 2011. Prices and offers are from that time.
What to Check When You Are Woken at Three in the Morning
Use a DBA on call checklist to establish impact, inspect blocking and disk space, review failed jobs, and choose a safe next step during incidents.
SQLAuthority News – Meeting SQL Friends – SQLPASS 2011 Event Log
The best part of SQLPASS 2011 was meeting SQL friends I usually only talk to on Facebook and Twitter. Here are a few of our photos together.