SQLSaturday #406 Kharkiv
September 19, 2015
SQLSaturday is a free training event for SQL Server professionals and those wanting to learn about SQL Server.
In this Pre-Con event we will cover a wide array of topics that form the backbone of my SQL Server performance analysis and tuning work.
We will cover many topics, including:
- Optimization processes.
- Statistics usage and maintenance.
- Index creation, usage and maintenance.
- Understanding query plans.
- Server and DB configuration.
- Improving design.
- Improving code.
- Profiler use and analysis.
- Temp object usage.
- Waits and IO stall analysis.
We will look at all of these things and more from a variety of angles, while also covering many of the tips, tricks, tools, etc.
