T-SQL Tips & Tricks
This session covers T-SQL tips and tricks in SQL Server 2005 and 2008. It provides tips regarding how to solve T-SQL problems that are non-trivial, and explains how to address common needs efficiently.
This session will cover topics such as calculating non-deterministic row numbers, generating a large virtual auxiliary table of numbers, enforcing uniqueness while allowing multiple NULLs, bushy join plans, date and time manipulation, sorting separated lists of values, inline scalar UDFs, maintaining custom sequences, and more as time permits.
Itzik Ben-Gan is a mentor with Solid Quality Mentors. He teaches, lectures, and consults internationally. He’s a SQL Server MVP and is the author of several books about T-SQL, including Inside Microsoft SQL Server 2008: T-SQL Querying (Microsoft Press), and he writes a monthly column for SQL Server Magazine. He is one of the founders of Solid Quality Learning, a global provider of education and solutions for the Microsoft database platform, and serves as its principal mentor.
Itzik has experience in designing, implementing, administrating, and programming with SQL Server, is the author of Solid Quality Mentors’ advanced T-SQL courseware, and is a primary resource for the company’s T-SQL-related activities, including many training events around the globe focused on T-SQL querying and programming, performance tuning, and Internals. Itzik’s speaking activities include Tech Ed, DevWeek, PASS, SQL Server Connections.