4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

T-SQL : Bad Habits & Best Practices

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. You will also learn about best practices that will help you avoid falling into some of these bad habits. Come learn how these 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.
Presented by Aaron Bertrand at SQLBits XII
  • Downloads
    Slide deck available Slide Deck 179 KB
    Samples available Demo Code 5 KB
    Video available MP4 Video HD 552 MB
  • SpeakerBIO
    Aaron is a senior consultant for SQL Sentry, makers of performance monitoring and event management software for SQL Server, Analysis Services, and Windows. He has been blogging at sqlblog.com since 2006, focusing on manageability, performance, and new features; has been an MVP since 1997-98; and speaks frequently at user group meetings and SQL Saturday events.
  • Video