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.