Abstract
The most dreaded call a DBA can get is this: “Everything in the application is slow! FIX IT!” In many cases, the database is one of the culprits of the poor performance of the legacy code. When you are approached to deal with some of these issues, what do you do? After painful code has been identified, you can perform triage for some immediate relief. Once that is accomplished, document the code thoroughly to identify any anti-patterns. This will help you as you rewrite the code using more performant techniques.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2020 Lisa Bohm
About this chapter
Cite this chapter
Bohm, L. (2020). T-SQL Triage. In: Refactoring Legacy T-SQL for Improved Performance. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5581-0_1
Download citation
DOI: https://doi.org/10.1007/978-1-4842-5581-0_1
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-5580-3
Online ISBN: 978-1-4842-5581-0
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)