Indexes That Have Not Been Used but Are Being Updated

Greg Larsen talks about how indexes that are not being used are costing you valuable resources and causing your update statements to run longer.

Why Are You Dropping and Recreating Your Indexes?

Do you have data load processes that drop indexes to optimize the load process? Are you dropping those indexes in one step, then loading data into your table, only to recreate the indexes in a post data load step?

Covering Indexes: Not Just for SELECT but also for UPDATE statements

Covering indexes help UPDATE performance also

Automated Indexes

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