Missing Index Impact and Join Type

Erik Darling shows how missing index requests have different impact numbers depending on the query's join type.

When Does Index Size Change Index Choice?

Erik purposely fragments indexes trying to slow down queries.

Index Fill Factor

SQL Server All Indexes Script

What are the indexes and types found in our tables?

Index Utilization Summary Report Script

Index Report Scripts ...

Limiting Indexing

Indexing for Windowing Functions: WHERE vs. OVER

Erik Darling shows that if you take SQL Server's word when it asks for an index, things can go horribly awry.

Index Creation

Index Utilization Summary

This report shows all the Indexes on user defined table or view and how effectively they are being used in our project.

One way to get an index seek for a leading %wildcard

In an effort to make leading wildcard searches sargable, Aaron Bertrand plays around with a trigram-type implementation in SQL Server.