Inspect the SQL Server plan cache, identify single-use plans and memory use, and understand what optimize for ad hoc workloads changes.
SQL SERVER – Updating Data in A Columnstore Index
A reader got an error when updating data in a columnstore index table. Here is why the table becomes read-only and what you can do about it.
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.
How to Read a SQL Server Execution Plan
An execution plan is SQL Server showing its working. Read it inside out, learn the six operators you actually meet, ignore the cost percentages, and compare estimated rows with actual rows instead.
Indexed Views: When the Faster Reads Are Worth It
Evaluate indexed views by building a sales summary, comparing read savings with write maintenance, and using NOEXPAND where required.
Puzzle – Usage of New Index Hints – ForceSeek and ForceScan
SQL Server Denali adds the FORCESCAN hint next to FORCESEEK. A weekend puzzle on these Index Hints: write a query where each one improves performance.