Name: NORTH - A Primer on SQL Server Clustered Index Architecture - Mike Byrd
Start: 2019-01-15T17:30:00-06:00
End: 2019-01-15T19:00:00-06:00
Location: Microsoft Corp

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.

John

Austin SQL Server User Group

Technology

SQL Server

Advanced SQL Server

Database Administrators

Database Development

Database Administrator

Database Professionals

SQL Azure

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

Microsoft Corp

Share

Austin SQL Server User Group

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

Austin SQL Server User Group

Details

Members are also interested in