Past Meetup

NORTH - A Primer on SQL Server Clustered Index Architecture - Mike Byrd

This Meetup is past

19 people went

Every 3rd Tuesday of the month

Location image of event venue

Details

How often when creating a new table you just made the Clustered Index using an Integer column with Identity properties. Seems like that is all I have done for last many years. But, in the last two years I’ve really dove into indexes and finally with this presentation looked at what really makes a good Clustered Index with benchmarks and varying scenarios. In some scenarios a well-defined clustered index may out perform a covering non-clustered index. Results are very interesting and may surprise you.