null
Loading…
Skip to main content

Holiday gifts by Fri, Dec 18? Order by Thu, Dec 3. Plan gifts

Free shipping works great on most orders over $95 in the contiguous US

Specialists Mon–Fri, 8:30 am–5 pm PTSpecialists Mon–Fri, 8:30–5 PT866-522-6657

Printed to order
Refactoring Legacy T-SQL for Improved Performance: Modern Practices for SQL Server Applications book cover by Lisa Bohm
Paperback

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

by Lisa Bohm

$38.49 / copy at 25+ copies As low as $34.09 at 1,000+Your best volume price

Total $962.25

Paperback · 236 pages Apress · 2020

Format

Paperback
Volume pricing

The more copies, the less each one costs

Applied automatically in your cart. No code needed.

More than a box of books

Turn this order into a program

Groups that order in bulk often pair the copies with something more. We handle the extras so you don't have to.

About the book

Refactoring Legacy T-SQL for Improved Performance

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.

Legacy code isn’t just found in queries and external applications. It’s also found in the definitions of underlying database objects such as views and tables. This book helps you quickly find problematic code throughout the database and points out where and how modern solutions can replace older code, thereby making your legacy applications run faster and extending their lifetimes. Author Lisa Bohm explains the logic behind each anti-pattern, helping you understand why each pattern is a problem and showing how it can be avoided. Good coding habits are discussed, including guidance on topics such as readability and maintainability. 


What You Will Learn
  • Find specific areas in code to target for performance gains
  • Identify pain points quickly and understand why they are problematic
  • Rewrite legacy T-SQL to reduce or eliminate hidden performance issues
  • Write modern code with an awareness of readability and maintainability
  • Recognize and correlate T-SQL anti-patterns with techniques for better solutions
  • Make a positive impact on application user experience in your organization

Who This Book Is For

Database administrators or developers who maintain older code, those frustrated with complaints about slow codewhen there is so much of it to fix, and those who want a head start in making a positive impact on application user experience in their organization



The book, Refactoring Legacy T-SQL for Improved Performance: Modern Practices for SQL Server Applications [Bulk, Wholesale, Quantity] ISBN#9781484255803 in Paperback by Lisa Bohm may be ordered in bulk quantities. Minimum starts at 25 copies. Availability based on publisher status and quantity being ordered.

Details

Publisher
Apress
Author
Lisa Bohm
Format
Paperback
Published
Jan 11, 2020
ISBN-13
9781484255803
Pages
236
Printing
Printed on demand
Buying for a group

Refactoring Legacy T-SQL for Improved Performance in bulk: pricing

Volume pricing applies automatically in your cart. No codes, no account needed.

CopiesPrice per copyYou save
25 – 99 $38.49 30% off list
100 – 249 $37.39 32% off list
250 – 499 $36.29 34% off list
500 – 999 $35.19 36% off list
1,000+ $34.09 38% off list
Ways groups use it

Popular for

1
Book clubs

A copy for every member, on one order.

2
Events and conferences

A book for every attendee, delivered to your venue.

3
Gifts

For clients, staff, members or volunteers.

How fast can I get copies of Refactoring Legacy T-SQL for Improved Performance?

This title is printed on demand, so it needs production time before it ships. Need them by a specific date? Request a quote and we'll confirm timing before you pay.

Can you ship to several locations or people's homes?

Yes. We ship in bulk to one address, to multiple sites, or to individual recipients, in the US and internationally. See fulfillment options.

Can I get a formal quote for approval before ordering?

Yes. Request a quote and we'll send a PDF you can forward for approval.

Do you accept purchase orders and tax-exempt orders?

Yes. We accept purchase orders upon approval, as well as cards, PayPal, ACH, wire transfers and checks. BookPal is a tax-exempt supplier in all 50 states. See purchase orders and sales tax exemption.

What if I find a lower price?

Send us the link. We match prices from other bulk booksellers and distributors on a new copy in the same edition, available to ship in the quantity you need. Clearance sales and pricing errors are the exception, and we'll tell you quickly if that's the case. Start a price match.

Send for approval

Get a yes from your approver

Refactoring Legacy T-SQL for Improved Performance: Modern Practices for SQL Server Applications
Email it to my approver

Your approver gets a link to this page with the quantity set and an "Approve and order" button. Nothing is sent until you press send in your email app.

Log In
Review Your Cart
Your cart is empty Your cart is empty Your cart is empty

Menu

Recently Viewed Recently Viewed
Back to top Back to top