Microsoft Transact-SQL: The Definitive Guide: The Definitive Guide

by Jeffrey Garbus

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:	06/04/2010
Edition description:	1E
Pages:	516
Product dimensions:	7.40(w) x 9.10(h) x 1.10(d)

About the Author

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.

Table of Contents

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