Download my Missing Index script, with a warning: do not create every index it suggests. Watch Avg_Estimated_Impact and keep to 5 to 10 indexes per table.
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 – Public Training and Private Training – Differences and Similarities – Public Training vs Private Training
This year I did 62% consultations and 38% trainings. Here are my thoughts on public training vs private training: the differences and the similarities.
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.