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

« All Events

  • This event has passed.

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

January 15, 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.