DBCC PAGE

How Filtered Indexes Look Like (Part 2)

In the first part of this series on Filtered Indexes, I talked about how SQL Server navigates through the index structure and used a clustered index as an example to demonstrate how the process works. To continue this series, we’ll look at filtered indexes and how they look like from a storage perspective. If you look at…

How Filtered Indexes Look Like (Part 1)

“During one of my SQL Server Index Internals presentation, an attendee asked me how filtered indexes look like and if they are stored exactly the way the traditional indexes are. I was tempted to show the internals of how filtered indexes looked like using DBCC PAGE during the presentation, but held back because it deserves…