A Rocket Scientist Perspective on Index Column Selection by Mike Byrd | SQLServer Virtual Conference

Ever wonder how to select what columns need to be in an index definition and what columns should be in the INCLUDE clause. This session will take a deep dive in looking at two SELECT queries on the AdventureWorks2017 database and what indexes give the best, adequate, and poor performance and their relation to disk space utilization. Sometimes what you have heard (word of mouth) is not always the overall best solution. In addition, ever wonder if covering indexes can be used for UPDATE statements -- the answer is yes and a demo will show that. And a final tidbit will be a demo of how an unused index can affect a SELECT statement's performing poorly. This session is about 60% demos and yields some surprising results. About Speaker: 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. Conference Website: https://www.2020twenty.net/sql-server-virtual-conference/ C# Corner - Community of Software and Data Developers https://www.c-sharpcorner.com #SQL #Bigdata #Csharpcorner #conference #sqlserver