Speaker

Mike Byrd

Mike Byrd

TSQL Mentor

Austin, Texas, United States

Former rocket scientist and USAF Fighter Pilot -- now a SQL Server geek. Past opportunities include free-lance technical writer for PC Magazine, Senior Software Manager for government sponsored munitions effectiveness committee, and IT Director for Texas Windstorm Insurance Association (9 years), Currently senior database consultant for several companies. Ideal job is stored procedure and query performance tuning or TSQL instruction. Presenter at many SQL Saturdays in US, Europe, and Australia.

Specialties
SQL Server performance tuning; database (OLTP & OLAP) architecture; trouble-shooting; teaching TSQL (Basic through Advanced).

Area of Expertise

  • Finance & Banking
  • Health & Medical
  • Information & Communications Technology

Topics

  • Microsoft SQL Server
  • performance tuning
  • Teaching Code
  • TSQ:

How Bad Are Bad Page Splits

Bad Page Splits are said to be bad for performance. This session will review what a bad page split is and continue with an example indicating actual CPU and IO costs as well as cost to a SELECT query.

A Primer on SQL Server Clustered Index Architecture

How often have you created a new table (where you defined the Clustered Index and Primary Key using an Integer column with Identity properties as usual) and never wondered about the performance effects of that process? Seems like that is all I have done for the past several years. But, recently in my index performance research, I am starting to realize a well-defined Clustered Index may improve the overall database performance. We will look at 8 typical report queries varying clustered and non-clustered indexes using the AdventureWorks2017 database benchmarking (cpu time, logical IOs, and query plan cost) for each scenario. Results are very interesting, and they may surprise you. In some instances, a well-defined clustered index may outperform a covering non-clustered index for a set of queries. This presentation should raise your clustered index intellect to the outer limits of index technology.

In-Memory Indexes: SpaceX® Performance!

A deep dive into performance of in-memory hash, range, and columnstore indexes. Compares performance to similar disk based indexes.

Climbing the SQL Server B-Tree

A page level glimpse of how SQL Server constructs and utilizes Clustered and Non-Clustered Indexes with emphasis on performance. Many demos; the attendee will leave with a much clearer understanding of improving index performance.

A Rocket Scientist Perspective on Indexes

A in-depth index view from the perspective of how indexes can improve performance. Many demos with emphasis on covering indexes.

SQL Saturday 878

Climbing the SQL Server Index B-Tree

October 2019 Sofia, Bulgaria

Mike Byrd

TSQL Mentor

Austin, Texas, United States