Microsoft Transact-SQL: The Definitive Guide

Description

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

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