Back to All Events

Performance Precon at SQL Saturday Redmond

SQLSaturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence and Analytics.

Register for this detail-packed seminar now!
This is the same content offered as a precon at large conferences, and it’s less than half the cost here!

For details about SQL Saturday Redmond, including the exact location, you can go here.

SQL Server Internals for Performance

We all know that the answer to almost any SQL Server tuning question is “It Depends!”

In this seminar, I’ll tell you what you need to know in order to figure out what it actually depends on! How can you answer these “It Depends” questions in your own environment? We’ll look at what kinds of tuning changes can be made to enhance your system or application performance, and what areas of SQL Server Internals you need to understand to make the best choice for you when trying to answer the following questions:

  1. Should we build a clustered, nonclustered or columnstore index?

  2. Is reusing cached query plans a good thing?

  3. Should I enable Read Committed Snapshot Isolation?

  4. How many files should tempdb be configured with?