Shaving off Micros Seconds

This session shows a series of techniques that each allows you to squeeze a few more microseconds out of an already perfectly tuned query or transaction. This is especially useful in cases where the code is run millions of times every day.
By and large none of these techniques should be considered best practice but there are extreme cases where it can be necessary to go to these extreme lengths to make the system faster. We will cover syntax options, SQL Server and database configurations, data types, connection options and security.
All the shown techniques are from real world cases where they helped solve a performance problem.
So, if you are a DBA or database developer and you are looking for inspiration on how to get fast transactions even faster this is the right session.
The presenter (Thomas Grohser) is working with SQL Server for over 30 years and will share what he learned working in some of the most demanding environments.

Learn what you can do in extreme cases to make a query/transaction go faster. Learn how to think about performance in extreme cases. Learn from 30 years of experience how to push the limits