Home » Events » A Primer on SQL Server Clustered Index Architecture » South Austin SQL Server User Group Meetup: A Primer on SQL Server Clustered Index Architecture with Mike Byrd
Loading Events

« All Events

  • This event has passed.

South Austin SQL Server User Group Meetup: A Primer on SQL Server Clustered Index Architecture with Mike Byrd

January 21, 2019 @ 5:30 pm - 7:00 pm

Free

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.