SQL Server Metrics Pack Update – September 2019
This morning I updated the Index Metrics piece of SQL Server Metrics Pack. This update mainly introduced some new functionality, with a few minor bug fixes. The two big enhancements …
SQL Scripts: How To Find Filtered Indexes
Filtered indexes are one of those neat little SQL Server features that a lot of people don’t seem to know about, or if they do they don’t use them very …
Index Basics: Find Tables That Do Not Have A Clustered Index
In a previous Index Basics post we went over the importance of having a Clustered Index on your tables, and we learned that SQL Server will automatically create a Clustered …
SQL Scripts: How To Find Index Fragmentation
This is the first post in an ongoing SQL Scripts series, in which I list useful queries that I use in my day to day database administration. What Is Index Fragmentation? …
Index Basics: Clustered Indexes
In SQL Server, an index is used to speed the retrieval of data from a table. Indexes are built from one or more columns in the table, and SQL Server uses these Indexes …