Microsoft Transact-SQL: The Definitive Guide

Microsoft Transact-SQL: The Definitive Guide

by Jeffrey Garbus
ISBN-10:
0763784168
ISBN-13:
9780763784164
Pub. Date:
05/21/2010
Publisher:
Jones & Bartlett Learning
Select a Purchase Option (1E)
  • purchase options
    $9.90 $46.95 Save 79%
    • Free return shipping at the end of the rental period details
    • Textbook Rentals in 3 Easy Steps  details
    icon-error
    Note: Access code and/or supplemental material are not guaranteed to be included with textbook rental or used textbook.
  • purchase options
    $39.43 $46.95 Save 16% Current price is $39.43, Original price is $46.95. You Save 16%.
  • purchase options
    $21.68 $46.95 Save 54% Current price is $21.68, Original price is $46.95. You Save 54%.
    icon-error
    Note: Access code and/or supplemental material are not guaranteed to be included with textbook rental or used textbook.
  • purchase options

Overview

Microsoft Transact-SQL: The Definitive Guide

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.

Product Details

ISBN-13: 9780763784164
Publisher: Jones & Bartlett Learning
Publication date: 05/21/2010
Edition description: 1E
Pages: 516
Product dimensions: 7.40(w) x 9.10(h) x 1.10(d)

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews