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 …