
Автор: by Lisa Bohm
Издательство: Apress
Год: 2020
Формат: PDF, EPUB
Страниц: 236
Размер: 11 Mb
Язык: English
Breathe new life into older applications by refactoring T-SQL queries and code using modern techniques. This book shows you how to significantly improve the performance of older applications by finding common anti-patterns in T-SQL code, then rewriting those anti-patterns using new functionality that is supported in current versions of SQL Server, including SQL Server 2019. The focus moves through the different types of database objects and the code used to create them, discussing the limitations and anti-patterns commonly found for each object type in your database.