Refactoring Legacy T-SQL for Improved Performance: Modern Practices for SQL Server Applications

Author:   Lisa Bohm
Publisher:   APress
Edition:   1st ed.
ISBN:  

9781484255803


Pages:   236
Publication Date:   11 January 2020
Format:   Paperback
Availability:   Manufactured on demand   Availability explained
We will order this item for you from a manufactured on demand supplier.

Our Price $54.99 Quantity:  
Add to Cart

Share |

Refactoring Legacy T-SQL for Improved Performance: Modern Practices for SQL Server Applications


Add your own review!

Overview

Full Product Details

Author:   Lisa Bohm
Publisher:   APress
Imprint:   APress
Edition:   1st ed.
Weight:   0.500kg
ISBN:  

9781484255803


ISBN 10:   1484255801
Pages:   236
Publication Date:   11 January 2020
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Paperback
Publisher's Status:   Active
Availability:   Manufactured on demand   Availability explained
We will order this item for you from a manufactured on demand supplier.

Table of Contents

Part I. Everything is Slow1. T-SQL Triage2. Documentation  Part II. Database Structure3. Database Tables4. Database Views Part III. CRUD Objects5. Triggers6. Stored Procedures7. Functions Part IV. The Bad and The Ugly8. Agent Jobs9. External Influences

Reviews

Author Information

Lisa Bohm leads a team of database administrators for a software development company. Her history with legacy database code began early in her career with a summer project to rewrite the chemical inventory database for the research division of a local VA hospital. From there, she went on to building front-end web applications. When the web calls timed out, Lisa dug in to learn what databases can do. She has since transitioned into database administration, inheriting and improving legacy applications along the way. Her personal focus remains on solid database architecture and writing well-performing T-SQL. 

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions
Latest Reading Guide

wl

Shopping Cart
Your cart is empty
Shopping cart
Mailing List