Viewing SQL Server Non-Clustered Index Page Contents

In this blog post I’ll take a look at what is actually stored in a non-clustered index and (re)introduce you to some tools that you can use for looking at the contents of a given data or index page.  Hopefully, by the end of the examples you’ll have a better idea as to what SQL…