In Part 1 of this article we looked at a specific use case (probably exaggerated) that gave us an idea about how CPU and IO performance might be affected by a bad page split. We continue this analysis looking at what really happens to the data on the leaf pages of a clustered index with […]
In this tip we look at the impact of building SQL Server indexes in ascending versus descending order and the impact.
Learn about the advantages and disadvantages of using INCLUDE columns in your index.
With origins from the world of “Submarine ‘Dolphin’ Qualification” questions, an “Oolie” is a difficult question to answer, or the knowledge or fact needed to answer such a question, that may or may not pertain to one's duties but tests one's knowledge of a system or process to the limit. Introduction Contrary to what many […]
In this tip we look at a PowerShell script you can use to collect index information for all of your SQL Server instances that you manage.
Can be useful when inserting a lot of data into a table.
This level of the Stairway to Exploring Database Metadata focuses on indexes and all the information you can gather about them.