|
|
|||
|
||||
OverviewAccording 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. Full Product DetailsAuthor: Jeffrey GarbusPublisher: Jones and Bartlett Publishers, Inc Imprint: Jones and Bartlett Publishers, Inc Dimensions: Width: 18.80cm , Height: 3.00cm , Length: 22.90cm Weight: 0.851kg ISBN: 9780763784164ISBN 10: 0763784168 Pages: 516 Publication Date: 04 June 2010 Audience: Professional and scholarly , Professional & Vocational Format: Paperback Publisher's Status: Active Availability: In Print This item will be ordered in for you from one of our suppliers. Upon receipt, we will promptly dispatch it out to you. For in store availability, please contact us. Table of ContentsReviewsAuthor InformationJeffrey Garbus is a database consultant and the CEO of Soaring Eagle Consulting, Ltd., based in Tampa, Florida. He has spoken at user conferences, and has written many magazine articles and books. He is also the lead author for Jeffrey Garbus’ Official Sybase ASE 12.5 Library from Wordware Publishing, which includes Sybase ASE 12.5 Performance and Tuning and Sybase ASE 12.5 High Availability. Tab Content 6Author Website:Countries AvailableAll regions |