SQL Server Tools, Tricks, and Techniques

SQT10 "What Did I Do?" T-SQL Worst Practices


2:00pm - 3:15pm

Level: Introductory to Intermediate

Pinal Dave

MS Computer Science

SQL Server Performance Tuning Expert

"Oh My God! What did I do?" Chances are you have heard, or even uttered, this expression. This demo-oriented session will have many examples where developers were dumbfounded by their own mistakes. The goal of this session is to learn which small details can be dangerous to the production environment and SQL Server as a whole. We will talk about common bad habits and how to avoid them. There is good chance you will remember your early days during the session. Learning some of these tricks may save your current job.

You will learn:

  • Writing Optimal Tips and Tricks
  • Basics of Indexes
  • Basics of Performance Tuning