Description: Microsoft Transact-SQL : The Definitive Guide, Paperback by Garbus, Jeffrey; Ratchev, Plamen; Chang, Alvin; Celko, Joe, ISBN 0763784168, ISBN-13 9780763784164, Used Good Condition, Free shipping in the US 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.
Price: 37.9 USD
Location: Jessup, Maryland
End Time: 2024-11-28T16:42:55.000Z
Shipping Cost: 0 USD
Product Images
Item Specifics
Return shipping will be paid by: Buyer
All returns accepted: Returns Accepted
Item must be returned within: 14 Days
Refund will be given as: Money Back
Return policy details:
Book Title: Microsoft Transact-SQL : The Definitive Guide
Number of Pages: 516 Pages
Language: English
Publication Name: Microsoft TransAct-Sql: the Definitive Guide
Publisher: Jones & Bartlett Learning, LLC
Publication Year: 2010
Subject: Desktop Applications / Databases, Databases / General
Item Height: 1 in
Item Weight: 30.1 Oz
Type: Textbook
Subject Area: Computers
Author: Jeffrey Garbus
Item Length: 9.1 in
Item Width: 7.4 in
Format: Trade Paperback