SQL Server Index Internals and How Filtered Indexes Look Like (Part 2)
In the first part of this series, I talked about how SQL Server navigates thru 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 the […]