Do Functions Stop You From Using Indexes?

If you have a function in the WHERE clause, you might have heard you can't use indexes. That's not entirely correct.

Pages and Extents: Stairway to SQL Server Indexes Level 4

We've now seen how indexed and non-indexed tables perform in queries, and established "logical reads" as the metric for query performance. Now it is time to explain why logical reads are an excellent metric and also explain what is actually being read.

Indexing Computed Columns

Unused Indexes - Are they really unused or have they just not been used YET?

Tara explains when index DMVs gets reset by telling a story from her dark past.

Index Tuning Week: How Many Indexes Are Too Many?

When you're not sure, start by aiming for 5 or less indexes per table, with 5 or less fields each.

sp_helpindex2

modernized sp_helpindex with info on post S2K features

Indexing the PO

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.

Finding a String Anywhere in Another String

Optimize searching for a string within another string with this string storage and indexing technique.