Fixing Queries through Advanced T-SQL Techniques with Rob Farley
Have you inherited queries that are not your own, and are finding that performance isn’t so great? Removing cursors in favour of set-based queries is useful, but even set-based queries can perform poorly. Understanding the impact of various constructs on a query plan can be key to resolving many of these issues.
In this seminar, SQL Server MVP Rob Farley will take a look at some real-life queries and take the class through examples of constructs that can have significant effects on tuning. This will include complex nested joins, join simplification, procedural functions, SARGability, execution plan reading, complex sorting, ORs, effective Dynamic SQL, GROUP BY v DISTINCT, unique indexes, temporary tables, and more.
This will be a day spent in Management Studio, not PowerPoint. If you want to know how to persuade the Query Optimizer to do a better job of running your query, this day is for you.
|