You might also like

Availability alert

More about Microsoft Transact-SQL: The Definitive Guide

• Book details
• Synopsis
• Trending among others

You get 133 loyalty points

Book synopsis

According to industry studies, 70-80% of database performance problems are caused by poorly written transact-SQL code. Microsoft Transact-SQL: The Definitive Guide is a comprehensive guide to the T-SQL language written for the MS SQL Server 2008 developer having performance problems with SQL. The text includes case studies and examples demonstrating how to write or rewrite T-SQL source code. Some Topics covered include several ways of writing code for optimal performance and maintainability such as stored procedures versus dynamic SQL as well as subqueries versus joins; advanced SQL programming techniques including characteristic functions, common table expressions, refactoring, cubes, and dynamic queries; methods for identifying and fixing poorly written code including Profiler, DMVs, third-party tools, and reading query plans.

Book details

Book category Books in English Computing & information technology Databases Database software

• Full title: Microsoft Transact-SQL: The Definitive Guide
• Author: Jeffrey Garbus
• Language: English
• Binding: Paperback
• Number of pages: 516
• EAN: 9780763784164
• ISBN: 0763784168
• ID: 04690215
• Publisher: Jones and Bartlett Publishers
• Weight: 912 g
• Dimensions: 189 × 232 × 28 mm
• Date of publishing: 21. May 2010

Trending among others

---

---

---