From the author of the bestselling books Inside Microsoft SQL Server 2005: T-SQL Querying and Inside Microsoft SQL Server 2005: T-SQL Programming this seminar is jam-packed with practical advice for T-SQL querying, programming and tuning.
The seminar covers practical problems T-SQL programmers face daily, providing different solutions for each problem, and explains in detail how to tune your code to produce robust and efficient applications.
Among the subjects that will be covered in this seminar: ranking calculations, window-based calculations, islands and gaps, running aggregations, custom aggregations, PIVOT on steroids, unpivoting, auxiliary table of numbers, splitting arrays, TOP on steroids, APPLY, paging, randomization, maintaining sequences, graphs, trees, hierarchies and recursive queries, T-SQL vs. CLR routines, regular expressions, dynamic filters, exception handling, and more…