Items related to Microsoft Transact-SQL: The Definitive Guide: The Definitive...
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.
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.
"synopsis" may belong to another edition of this title.
About the Author:
CEO, Soaring Eagle Consulting, Ltd., Tampa, Florida
"About this title" may belong to another edition of this title.
- PublisherJones & Bartlett Learning
- Publication date2010
- ISBN 10 0763784168
- ISBN 13 9780763784164
- BindingPaperback
- Number of pages516
- Rating
Buy New
Learn more about this copy
US$ 27.53
Shipping:
US$ 1.75
Within U.S.A.
Top Search Results from the AbeBooks Marketplace
Stock Image
Microsoft Transact-SQL: The Definitive Guide - FIRST EDITION
Published by
Jones & Bartlett Learning, USA
(2010)
ISBN 10: 0763784168
ISBN 13: 9780763784164
New
No binding
Quantity: 3
Seller:
Rating
Book Description No binding. Condition: New. Dust Jacket Condition: New. Book NEW. We do not ship to Po Box, APO, FPO address and Internationally. Note: 5 to 14 days for delivery. Seller Inventory # J230900784
Buy New
US$ 27.53
Convert currency
Stock Image
Microsoft Transact-SQL: The Definitive Guide: The Definitive Guide
Published by
Jones & Bartlett Learning
(2010)
ISBN 10: 0763784168
ISBN 13: 9780763784164
New
Paperback
Quantity: 1
Seller:
Rating
Book Description Paperback. Condition: new. New. Seller Inventory # Wizard0763784168
Buy New
US$ 45.21
Convert currency
Seller Image
Microsoft Transact-SQL : The Definitive Guide
Published by
Jones & Bartlett Learning
(2010)
ISBN 10: 0763784168
ISBN 13: 9780763784164
New
Softcover
Quantity: 3
Seller:
Rating
Book Description Condition: New. Seller Inventory # 9576619-n
Buy New
US$ 46.19
Convert currency
Stock Image
Microsoft Transact-SQL: The Definitive Guide: The Definitive Guide
Published by
Jones & Bartlett Learning
(2010)
ISBN 10: 0763784168
ISBN 13: 9780763784164
New
Paperback
Quantity: 1
Seller:
Rating
Book Description Paperback. Condition: new. New Copy. Customer Service Guaranteed. Seller Inventory # think0763784168
Buy New
US$ 45.29
Convert currency
Stock Image
Microsoft Transact-SQL: The Definitive Guide: The Definitive Guide
Published by
Jones & Bartlett Learning
(2010)
ISBN 10: 0763784168
ISBN 13: 9780763784164
New
Paperback
First Edition
Quantity: 2
Seller:
Rating
Book Description Paperback. Condition: New. 1st Edition. Ships in a BOX from Central Missouri! UPS shipping for most packages, (Priority Mail for AK/HI/APO/PO Boxes). Seller Inventory # 001050918N
Buy New
US$ 45.96
Convert currency
Stock Image
Microsoft Transact-Sql: The Definitive Guide [Paperback] Garbus, Jeffrey
Published by
Jones & Bartlett Learning
(2010)
ISBN 10: 0763784168
ISBN 13: 9780763784164
New
Softcover
Quantity: 1
Seller:
Rating
Book Description Condition: New. New. In shrink wrap. Looks like an interesting title! 2.01. Seller Inventory # Q-0763784168
Buy New
US$ 89.39
Convert currency
Seller Image
Microsoft Transact-SQL : The Definitive Guide
Published by
Jones & Bartlett Learning
(2010)
ISBN 10: 0763784168
ISBN 13: 9780763784164
New
Softcover
Quantity: 3
Seller:
Rating
Book Description Condition: New. Seller Inventory # 9576619-n
Buy New
US$ 79.53
Convert currency
Stock Image
Microsoft Transact-SQL: The Definitive Guide: The Definitive Guide
Published by
Jones & Bartlett Learning
(2010)
ISBN 10: 0763784168
ISBN 13: 9780763784164
New
Paperback
Quantity: 1
Seller:
Rating
Book Description Paperback. Condition: new. Brand New Copy. Seller Inventory # BBB_new0763784168
Buy New
US$ 103.57
Convert currency