Publisher's Synopsis
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 joinsAdvanced SQL programming techniques including characteristic functions, common table expressions, refactoring, cubes, and dynamic queriesMethods for identifying and fixing poorly written code including Profiler, DMVs, third-party tools, and reading query plansTactics for troubleshooting T-SQL queries A comprehensive guide to the T-SQL languageAn approach to troubleshooting T-SQL queriesIncludes case studies and examples demonstrating how to write or rewrite T-SQLProvides instruction on identifying and fixing legacy T-SQL codeGeared towards the most recent release of SQL Server 2008 © 2011 | 516 pages
