Itzik Ben-Gan
sqlperformance.com/author/itzikbengan
Itzik Ben-Gan is a T-SQL trainer at and co-founder of Lucient. He is a Microsoft Data Platform MVP, author of many T-SQL books, and a regular speaker at SQL Server related conferences.
SQLBits 2014
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.
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.