Shaving Off Microseconds

Abstract: This session is a compilation of extreme techniques I had to use over time to make very fast operations go a bit faster. It will cover multiple areas (indexing, table design, data access layer, schemas, object naming, datatypes, collations physical data placement and more. All examples given in this session are from real world cases of some of the most demanding workloads in the world.

Speaker Bio: Thomas Grohser for the past 27+ years has spent most of his time exploring the deeper inner workings of SQL Server and its features while working for entertainment, pharmaceutical and financial services industries. His primary focus is to architect, plan, build and operate reliable, highly available, secure and scalable infrastructures for SQL Server. Over the years he managed thousands of SQL Server instances processing trillions of rows taking up petabytes of storage. Thomas is a Microsoft Data Platform (former SQL Server) MVP.