A Rocket Scientist Perspective on Indexes

Abstract:

Performance! Performance! Performance! That’s what the rocket scientist and SQL Developer are looking for. Indexes can offer significant performance benefits, but can also be a detriment to overall database performance. This session will focus on a deep dive into clustered indexes (including B-tree traversal), Primary Keys, and non-clustered indexes, their syntax and utilization, and their effect on performance in transaction and data warehouse databases. Covering non-clustered indexes will also be examined in detail with emphasis on when and when not to use. Included will be many live query demos illustrating index utilization and performance using statistics and query plans.

Speakers:

  • Mike Byrd

    9 Recordings

    Former rocket scientist and USAF Fighter Pilot -- now a SQL Server geek (24 years)! Past opportunities include free-lance technical writer for PC Magazine, Senior Software Manager for government sponsored munitions effectiveness committee, and insurance company CTO. Currently senior database engineer consultant for several Austin companies. Presenter at 17 SQL Sat sessions in 2016, 10 in 2017, 8 in 2018 (Cambridge) and Chicago, Jacksonville, Dallas, Pensacola, Austin, and Baton Rouge in 2019; as well as several local SQL Server user's groups in Ft. Worth, Austin, and San Antonio; and 2 Virtual DBA presentations in 2018.

Recorded At:

Recorded on:

Aug 25, 2018

More Info:

http://www.sqlsaturday.com/794/Sessions/Details.aspx?sid=82648

Tags: