Microsoft Transact-Sql: The Definitive Guide

  • 21% OFF
  • $42.60
  • Regular price $54.14
  • Publish Date: 2010-06-04
  • Binding: Paperback
  • Author: Jeffrey Garbus

Free shipping

Free Shipping On All Orders(Domestic Only).

Free Returns

Free 30 Days Returns. Returns & Refund Policy

Secure Shopping Guarantee

We use Secure Sockets Layer (SSL) technology to provide you with the safest, most secure shopping experience possible.


Attention: For textbook, access codes and supplements are not guaranteed with used items.



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.

Customer Reviews


MORE FROM THIS COLLECTION

Recently Viewed Items