SQLBits 2011

T-SQL : Bad Habits to Kick

This session will explore a handful of T-SQL practices - why they happen, why they're bad, and how we can work around them.

Bad habits: we all have them. SELECT * is the obvious one; but in this session you will learn about various other habits and why they can be bad for performance or maintainability. Come learn how these habits develop, what kind of problems they can lead to, and how you can avoid them. Eliminating these habits will lead to more efficient code, a more productive work environment, and - in a lot of cases - both.

Aaron Bertrand's previous sessions

New T-SQL Capabilities in SQL Server 2016 & v.Next

Discover the ins and outs of some of the newest capabilities of our favorite data language, and walk away with a long list of reasons to consider upgrading to the latest version - or the next version.

T-SQL : Bad Habits & Best Practices

Come learn how bad habits develop, what kind of problems they can lead to, and how you can avoid them - leading to more efficient code, a more productive work environment, and - in a lot of cases – both.

Five Ways to Write More Effective Triggers

Many triggers are inefficient and violate best practices, but it doesn't have to be this way. Join this session and learn how to improve your triggers and keep them off the list of potential scapegoats for your SQL Server performance woes.

Practical T-SQL Tips & Tricks to coding problems

In this demo-packed session, you’ll learn practical tips and tricks for SQL code tuning from experienced SQL Server MVPs Aaron Bertrand and Kevin Kline as they walk you through some of the most problematic and troublesome SQL coding problems.

T-SQL : Bad Habits & Best Practices

Come to this session to learn how bad habits develop, the problems they lead to, and how you can avoid them.

T-SQL : Bad Habits & Best Practices

This session will cover a collection of minor bad habits that can occasionally lead to major problems, and a set of best practices that you should always have in mind.

T-SQL : Bad Habits to Kick

This session will explore a handful of T-SQL practices - why they happen, why they're bad, and how we can work around them.