Description:

Title: SQL Statement Tuning with SET and DBCC

Level: 100

Abstract: Writing a SQL SELECT statement that returns the data you want is usually quite easy, but ensuring that the SELECT statement runs optimally is often more difficult. This session will teach you the skills you need, using SET and DBCC statements, to profile the resource consumption of a SQL statement, compare the statement to alternatives, and choose the best possible SQL statement.

Prerequisites: Beginning SQL query writing skills