Optimizing Databases for T-SQL
Elizabeth L. Noble · Apress eBooks · 2023
In this part of the book, I have gone over many aspects of writing T-SQL code. I started by going over the use of set-based design in queries. When designing queries, it is also be important to design queries that use hardware effectively. One way to check the performance of your queries is by using execution plans. Once you have the execution plan of the query you want to improve, you can start focusing on how to optimize the query. There are some options available when it comes to optimizing T-SQL.