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.