| Microsoft Transact-Sql: The Definitive Guide: The Definitive Guide Contributor(s): Garbus, Jeffrey (Author) |
|
 |
ISBN: 0763784168 ISBN-13: 9780763784164 Publisher: Jones & Bartlett Publishers OUR PRICE: $47.45 Product Type: Paperback - Other Formats Published: May 2010 |
| Additional Information |
| BISAC Categories: - Computers | Document Management - Computers | Desktop Applications - Databases - Computers | Computer Science |
| Dewey: 005.756 |
| LCCN: 2010011832 |
| Physical Information: 1.2" H x 7.4" W x 9" (1.95 lbs) 516 pages |
| Descriptions, Reviews, Etc. |
| Publisher 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. Some Topics covered include 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. |
Contributor Bio(s): Garbus, Jeffrey: - CEO, Soaring Eagle Consulting, Ltd., Tampa, Florida |