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 Kevin Kline (author of SQL in a Nutshell) 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 the free tools that will significantly improve the way that you work!
(no tags)