Introduction When we talk about SQL Server indexes, we are usually discussing the rowstore clustered or non-clustered index. However, along with...
Pinal Dave
read more
Filtered Indexes and Performance
Introduction During a recent SQL Server Performance Tuning consultation, I was asked a fascinating question by a Senior DBA working with me from the...
Troubleshooting Over-Indexing for Performance
Introduction I have now warned several times against the mindset that suggests indexing is a silver bullet for SQL Server performance. In the...
Troubleshooting Under-Indexing for Performance
Introduction All too often, people treat a good index as a silver bullet in terms of SQL Server performance. It is well-known that we will encounter...
Beginning Indexes for SQL Server Performance
Introduction People often characterize indexes as silver bullets for the performance issues in SQL Server. Is it true? Well, yes and no. In this...
3 Critical Tasks DBAs Wish They Had More Time to Complete
People are constantly asking me what to do to make money. My answer is, “I spend time with people who have trouble with SQL Server Performance...