TSQL Techniques – Why and how to tune a routine
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.
- Downloads
- SpeakerBIO
Dave is a freelance SQLServer database developer / designer and has been working in the IT field for over 20 years, the past 15 of which has been specialising within SQLServer environment. Dave regularly contributes to online forums and is a regular speaker at UK events such as SQL Bits and user groups. He also is founder of the Kent .NET/SqlServer user group.
- Video
- Session Files Explorer
The network name cannot be found.