SQLBits 2014

Top Tools for Tuning SQL

In this demo-packed session, you’ll learn practical tips and tricks for SQL code tuning from experienced Microsoft SQL Server MVPs Aaron Bertrand and SQL in a Nutshell author Kevin Kline
In this demo-packed session, you’ll learn practical tips and tricks for SQL code tuning from experienced Microsoft SQL Server MVPs Aaron Bertrand and SQL in a Nutshell author Kevin Kline as they walk you through some of the most problematic and troublesome SQL coding problems.  Using both free and paid tools from SQL Sentry, you’ll learn tips and tricks you can take home and immediately apply to your SQL code. You’ll learn things like what’s the best way to write a cursor, a quick trick that can save you 20-30% processing times on your big stored procedures, some major T-SQL bad habits, and even some new SQL Server 2014 features. And, you might end up seeing something in free tools that will significantly improve the way that you work