Microsoft Transact-SQL: The Definitive Guide

by Garbus, Jeffrey

• ISBN13: 9780763784164
• ISBN10: 0763784168
• Edition: 1st
• Format: Paperback
• Copyright: 2010-06-04
• Publisher: Jones & Bartlett Learning

Summary

SQL Server 2008 is a database management system (DBMS) which has enormous and increasing market penetration worldwide for corporations from one-person startups to Fortune 10 corporations. It is used to contain and manage data. Transact-SQL is the proprietary language extension with which database code is written. 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.

Author Biography

Jeffrey Garbus is a leading database consultant and the CEO of Soaring Eagle Consulting, Ltd. He has over 20 years of experience consulting, tuning, and training on the Microsoft SQL Server. A frequent conference speaker, Mr. Garbus has written a dozen books and countless magazine articles on SQL, SQL Server and Sybase® He is also the host of the Accelerated SQL Performance Series, a webinar series designed to improve SQL performance.
Palamen Ratchev is the founder of Tangra, a firm specializing in relational database applications analysis, imokelementation and tuning Mr. Ratchev has a master's degree in Computer Science and holds numerous Microsoft certifications including Most Valuable Professional (MVP) for SQL Server.
Alvin Chang is a database systems consultant, technical trainer, and author of several books and training materials on SQL Server. He has been working with SQL Server for over 10 years.
Joe Celko served for 10 years on the ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards He is the author of over 800 columns and eight books on SQL.

Table of Contents

ChapterChapter 1 Introduction
ChapterChapter 2 SQL Basics
ChapterChapter 3 Tables
ChapterChapter 4 Views
ChapterChapter 5 Built-in Functions and Set Options
ChapterChapter 6 Programming Basics
ChapterChapter 7 Transactions
ChapterChapter 8 Cursors
ChapterChapter 9 Stored Procedures
ChapterChapter 10 User Defined Functions
ChapterChapter 11 Triggers
ChapterChapter 12 CTE
ChapterChapter 13 Understanding Graphical Query Plans
ChapterChapter 14 Indexes
ChapterChapter 15 Join Optimization
ChapterChapter 16 Subquery Optimization
ChapterChapter 17 Hardware
ChapterChapter 18 Set Oriented Programming versus Procedural Code
ChapterChapter 19 Dynamic SQL
ChapterChapter 20 Grouping Data
ChapterChapter 21 Refactoring
ChapterChapter 22 Why Other People's Code Stinks
ChapterChapter 23 Case Study #1
ChapterChapter 24 Case Study #2
ChapterChapter 25 Case Study #3