3 How to Visualize Indexes
In How to Think Like the Engine, I gave you a couple of simple PDF files that look like Excel spreadsheets, and we used those to simulate SQL Server’s 8KB data pages. Now, let’s learn how to build those yourself, and use them while we start testing index tuning to understand why SQL Server uses […]