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 …
Index Basics: Hidden Costs Associated With Indexes
I have a confession. When I was a developer, I didn’t understand indexes in SQL Server. I rarely added them to my tables, and when I did there was not …
Persist And Aggregate Index Stats Across Server Restarts
Maintaining indexes can be an important part of a DBA’s job. Researching an index to determine how useful it is, or if it needs to be removed, is something I …
Using PowerShell To Store sp_BlitzIndex Results In A Table
I really like Brent Ozar’s sp_BlitzIndex procedure. It offers a lot of great insight into the indexes in your databases. If you are not currently using it, you should check it …
Finding Recurring Index Fragmentation Issues
One of the nice things about Ola Hallengren’s maintenance solution is that it has the option to log its operations to a table. This gives you ability to do a …
Index Basics: Nonclustered Indexes, Part 1
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 …
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 …