Page Tools:

Microsoft Transact-SQL: The Definitive Guide

Author(s): Jeffrey Garbus, CEO, Soaring Eagle Consulting, Ltd., Tampa, Florida
Details:
  • ISBN-13: 9780763784164
  • Paperback    516 pages      © 2011
Price: $46.95 US List
Add to Cart Request a Review Copy

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.

Topics Covered:

  • 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
  • Tactics for troubleshooting T-SQL queries

Features & Benefits

  • A comprehensive guide to the T-SQL language
  • An approach to troubleshooting T-SQL queries
  • Includes case studies and examples demonstrating how to write or rewrite T-SQL
  • Provides instruction on identifying and fixing legacy T-SQL code
  • Geared towards the most recent release of SQL Server 2008
  Chapter 1  Introduction
  Chapter 2  SQL Basics
  Chapter 3  Tables
  Chapter 4  Views
  Chapter 5  Built-in Functions and Set Options
  Chapter 6  Programming Basics
  Chapter 7  Transactions
  Chapter 8  Cursors
  Chapter 9  Stored Procedures
  Chapter 10  User Defined Functions
  Chapter 11  Triggers
  Chapter 12  CTE
  Chapter 13  Understanding Graphical Query Plans
  Chapter 14  Indexes
  Chapter 15  Join Optimization
  Chapter 16  Subquery Optimization
  Chapter 17  Hardware
  Chapter 18  Set Oriented Programming versus Procedural Code
  Chapter 19  Dynamic SQL
  Chapter 20  Grouping Data
  Chapter 21  Refactoring
  Chapter 22  Why Other People’s Code Stinks
  Chapter 23  Case Study #1
  Chapter 24  Case Study #2
  Chapter 25  Case Study #3

Jeffrey Garbus-CEO, Soaring Eagle Consulting, Ltd., Tampa, Florida

Jeffrey Garbus is a database consultant and the CEO of Soaring Eagle Consulting, Ltd., based in Tampa, Florida. He has spoken at user conferences, and has written many magazine articles and books. He is also the lead author for Jeffrey Garbus’ Official Sybase ASE 12.5 Library from Wordware Publishing, which includes Sybase ASE 12.5 Performance and Tuning and Sybase ASE 12.5 High Availability.