But it worked great in Dev! Perfomance for Devs
DBA / DEV
If you've ever found yourself stating the above, this session is for you. For many developers, writing T-SQL that works is not the challenge. But too often, functional T-SQL is not the same as good T-SQL. In this session, we will examine why "SQL that works" is not good enough. Understanding indexes, exectuion plans, sargability, and more are all critical to writing good T-SQL. We will also examine several real-world examples of T-SQL that "worked great in dev" but caused major issues when it hit production.