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.

Slide Deck 68 KB , SQL Scripts 6 KB , MP4 Video Low 55 MB , MP4 Video Med 73 MB , MP4 Video High 156 MB