As the session title suggests, we will talk about techniques, tricks, objects, tools, settings, and other magic that allow us to improve the performance of Transact-SQL queries and commands, without changing the code.

Sometimes you have no access to the code cause you bought a 3rd party tool with no source control, sometimes Transact-SQL code is in the application as ad-hoc, which means that you have to look for it somewhere in the code repository, and provided you have access there, you are still not sure whether you are pulling the right version so that by changing the code, you might accidentally make additional changes and break other functionalities.

In incident situations, even if you have access to the code (in sensitive applications or apps and services in companies and institutions that are sensitive to changes) you are often forced to wait for approvals for the change, and most often from people who have no clue about what you plan to do.

In the mentioned situations, the examples covered in this session will be of great help to the people in charge of performance tuning.