Microsoft Transact-SQL: The Definitive Guide by Jeffrey Garbus | 9780763784164 | Paperback | Barnes & Noble
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

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

Overview

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
Sales rank:
1,169,884
Product dimensions:
7.40(w) x 9.10(h) x 1.10(d)

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >