There are many anti-patterns that SQL Server consultants find during query tuning
engagements. This is especially true at shops where developers use techniques that make
sense in procedural code to write T-SQL. Microsoft has made many advancements in the optimizer over the past few versions that overcome some of the issues with some of these techniques like table variables and user defined functions. Attend this session to learn about these enhancements, when they will and when they won’t help performance without making code changes.