Indexing a Computed Column

SQL Server Index Tutorial Overview

Although there are many different things that can be done to improve the performance of a database system, creating an index is the main tool in every DBA's toolbox that is used when we are trying to improve the performance of a query.

Be Careful with Key Order in SQL Server Missing Index Recommendations

In this tip we look at the missing index recommendations that SQL Server automatically provides and why you should pay close attention to what is recommended and how you actually implement the new index.

Stats_ID

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.