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
Slide Deck 234 KB
Demo Code 22 KB
MP4 Video HD 549 MB
MP4 Video HD 549 MB