T-SQL Tips and Tricks
The purpose of this
session is to have some fun with T-SQL and to learn practical tips and tricks
that will help you improve and optimize your solutions. For example, you will
learn about performance problems related to using multiple predicates and will
be given tips on how to address those problems. You will learn about tips
concerning indexing as well as tips concerning various query constructs. Join
this session, have fun, and learn a few practical tips along the way.
Itzik Ben-Gan is a Mentor and Co-Founder of SolidQ. A SQL Server Microsoft MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL Querying, Query Tuning and Programming. Itzik is the author of several books including Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions and Microsoft SQL Server 2012 T-SQL Fundamentals. He has written articles for SQL Server Pro, SolidQ Journal and MSDN. Itzik's speaking activities include TechEd, SQLPASS, SQLU, SQLTeach and various user groups around the world. Itzik is the author of SolidQ's Advanced T-SQL Querying, Programming and Tuning and T-SQL Fundamentals courses along with being a primary resource within the company for their T-SQL related activities.