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.
Presented by Dave Ballantyne at SQLBits VII
  • Downloads
  • SpeakerBIO
    dave_ballantyne.jpg

    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 and currently is supporting the London SQL community by organizing the "SQL Supper" user group.  He takes a keen interest in all things SQL and data related and is never happier than picking apart a poorly executing query.  He has also created an open sourced add-in for SQL Server data tools (SSDT) called "TSQL Smells".  This detects and reports on 'suspect'  code within a project and can be found at http://tsqlsmellsssdt.codeplex.com . Outside of work he is husband, father of 3 and exasperated archer.

    http://www.clearskysql.co.uk http://dataidol.com/davebally/feed/
  • Video