The product you are seeking was not found, or has been deleted. Please go back and try again.
Microsoft Transact-SQL: The Definitive Guideselected product title
First Edition
Jeffrey Garbus
ISBN:9780763784164
| © 2011
| 516 pages
Place Your Order
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
- A comprehensive guide to the T-SQL language
- An approach to troubleshooting T-SQL queries
- Includes case studies and examples demonstrating how to write or rewrite T-SQL
- Provides instruction on identifying and fixing legacy T-SQL code
- Geared towards the most recent release of SQL Server 2008
© 2011 | 516 pages