• Sign In
  • Help
  • My Basket0
Microsoft Transact-SQL: The Definitive Guide (Paperback)
  • Microsoft Transact-SQL: The Definitive Guide (Paperback)

Microsoft Transact-SQL: The Definitive Guide (Paperback)

Paperback 516 Pages / Published: 21/05/2010
  • Publisher out of stock

Currently unavailable to order

This product is currently unavailable.

  • This item has been added to your basket

Check Marketplace availability

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.

Publisher: Jones and Bartlett Publishers, Inc
ISBN: 9780763784164
Number of pages: 516
Weight: 851 g
Dimensions: 229 x 188 x 30 mm

You may also be interested in...

SQL Queries for Mere Mortals
Added to basket
T-SQL Querying
Added to basket
Querying Microsoft (R) SQL Server (R) 2012
Added to basket


Please sign in to write a review

Your review has been submitted successfully.