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.
Presented by Itzik Ben-Gan at SQLBits XII
  • Downloads
    Slide deck available Slide Deck 234 KB
    Samples available Demo Code 22 KB
    Video available MP4 Video HD 549 MB
    Video available MP4 Video HD 549 MB
  • SpeakerBIO
    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 T-SQL Querying (Microsoft Press, 2015) and T-SQL Fundamentals (Microsoft Press, 2012). He has written articles for SQL Server Pro, SolidQ Journal and MSDN. Itzik's speaking activities include TechEd, SQLPASS, IT/Dev Connections, 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.
  • Video