Dave Ballantyne
clearskysql.co.uk
Dave is a freelance SQL Server database architect / designer / developer / consultant and lives near London, England. He is a regular speaker at UK and European events and user groups.
SQLBits 2010
TSQL Techniques - Why and how to tune a routine
An overview of some everyday TSQL tuning techniques.
So, you’ve got good design, got correct indexes, hell, you’ve even got good sargability. But your system is still slow. What’s the problem? The chances are your SQL Code is asking too much of your hardware.
In this session, I will demonstrate why a set-based mindset is so critical to performance and some simple techniques to lower resource usage through better use of TSQL code.