This Missing Index Script ranks the indexes SQL Server wishes it had by a plain score and builds a CREATE INDEX statement for each. Read the key order, the INCLUDE list and the overlap before you create one. A garden center orders table shows the logical reads drop from 3,138 pages to 3.
SQL SERVER – Plan Cache and Data Cache in Memory
Two scripts I share with clients all the time: they show the plan cache and data cache in memory, with cached plans by size and cached pages by table.
SQL SERVER – Server Side Paging in SQL Server Denali – Part2
Part 2 of server side paging in SQL Server Denali: a reader keeps rows per page and page number in a table, and OFFSET and FETCH can read them from there.
SQLAuthority News – 18 Seconds of Fame – My PASS Experience
At SQLPASS someone asked me for 15 seconds on camera and I forgot all about it. Today I found out about that clip: my 18 seconds of fame from PASS.
SQL SERVER – Index Created on View not Used Often – Observation of the View – Part 2
A reader asked what happens when we create an index on the base table as well as on the view. Part 2 of my observation of the view looks at both cases.
SQL SERVER – Index Created on View not Used Often – Observation of the View
When is an index created on view actually used? After showing it is often ignored, I demonstrate a condition where SQL Server uses it, including NOEXPAND.
SQL SERVER – Server Side Paging in SQL Server 2012 Performance Comparison
A quick performance comparison of server side paging in SQL Server 2012, split into two tests, with a focus on the unnecessary IO reads that make paging costly.