Items related to Microsoft Transact-SQL: The Definitive Guide
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 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
"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.
Other Popular Editions of the Same Title
Search results for Microsoft Transact-SQL: The Definitive Guide
Stock Image
Microsoft Transact-SQL: The Definitive Guide: The Definitive Guide
Published by
Jones & Bartlett Learning, 2010
ISBN 10: 0763784168
ISBN 13: 9780763784164
Used
Paperback
Seller: HPB-Red, Dallas, TX, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Good. Connecting readers with great books since 1972! Used textbooks may not include companion materials such as access codes, etc. May have some wear or writing/highlighting. We ship orders daily and Customer Service is our top priority! Seller Inventory # S_456780235
Stock Image
Microsoft Transact-SQL: The Definitive Guide: The Definitive Guide
Published by
Jones & Bartlett Learning, 2010
ISBN 10: 0763784168
ISBN 13: 9780763784164
Used
paperback
Seller: One Planet Books, Columbia, MO, U.S.A.
Seller rating 4 out of 5 stars
paperback. Condition: Good. Illustrated. Ships in a BOX from Central Missouri! May not include working access code. Will not include dust jacket. Has used sticker(s) and some writing and/or highlighting. UPS shipping for most packages, (Priority Mail for AK/HI/APO/PO Boxes). Seller Inventory # 001050918U
Stock Image
Microsoft Transact-SQL: The Definitive Guide: The Definitive Guide
Published by
Jones & Bartlett Learning, 2010
ISBN 10: 0763784168
ISBN 13: 9780763784164
Used
paperback
Seller: Textbooks_Source, Columbia, MO, U.S.A.
Seller rating 5 out of 5 stars
paperback. Condition: Good. Illustrated. Ships in a BOX from Central Missouri! May not include working access code. Will not include dust jacket. Has used sticker(s) and some writing or highlighting. UPS shipping for most packages, (Priority Mail for AK/HI/APO/PO Boxes). Seller Inventory # 001050918U
Stock Image
Microsoft Transact-SQL: the Definitive Guide
Seller: PBShop.store UK, Fairford, GLOS, United Kingdom
Seller rating 5 out of 5 stars
PAP. Condition: New. New Book. Shipped from UK. Established seller since 2000. Seller Inventory # FW-9780763784164
Buy New
£ 36.63
£ 5.87 shipping
Ships from United Kingdom to U.S.A.
Ships from United Kingdom to U.S.A.
Quantity: 1 available
Stock Image
Microsoft Transact-SQL: the Definitive Guide (Paperback)
Published by
Jones and Bartlett Publishers, Inc, Sudbury, 2010
ISBN 10: 0763784168
ISBN 13: 9780763784164
New
Paperback
Seller: Grand Eagle Retail, Bensenville, IL, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: new. Paperback. 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. "Microsoft Transact-SQL" 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. Shipping may be from multiple locations in the US or from the UK, depending on stock availability. Seller Inventory # 9780763784164
Stock Image
Microsoft TransactSQL: The Definitive Guide The Definitive Guide
Seller: Revaluation Books, Exeter, United Kingdom
Seller rating 5 out of 5 stars
Paperback. Condition: Brand New. 1st edition. 350 pages. 9.00x7.25x1.00 inches. In Stock. Seller Inventory # __0763784168
Buy New
£ 36.64
£ 12.50 shipping
Ships from United Kingdom to U.S.A.
Ships from United Kingdom to U.S.A.
Quantity: 1 available
Stock Image
Microsoft Transact-SQL: The Definitive Guide
Published by
Wordware Publishing, 2010
ISBN 10: 0763784168
ISBN 13: 9780763784164
New
Softcover
First Edition
Seller: Kennys Bookshop and Art Galleries Ltd., Galway, GY, Ireland
Seller rating 5 out of 5 stars
Condition: New. "Microsoft Transact-SQL" 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. Num Pages: 516 pages, black & white illustrations. BIC Classification: UNSJ. Category: (P) Professional & Vocational. Dimension: 189 x 232 x 28. Weight in Grams: 912. . 2010. 1st Edition. Paperback. . . . . Seller Inventory # V9780763784164
Stock Image
Microsoft Transact-SQL: The Definitive Guide: The Definitive Guide
Published by
Jones & Bartlett Learning, 2010
ISBN 10: 0763784168
ISBN 13: 9780763784164
New
Softcover
Seller: SHIMEDIA, Brooklyn, NY, U.S.A.
Seller rating 4 out of 5 stars
Condition: New. Satisfaction Guaranteed or your money back. Seller Inventory # 0763784168
Stock Image
Microsoft Transact-SQL: The Definitive Guide
Seller: Kennys Bookstore, Olney, MD, U.S.A.
Seller rating 5 out of 5 stars
Condition: New. "Microsoft Transact-SQL" 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. Num Pages: 516 pages, black & white illustrations. BIC Classification: UNSJ. Category: (P) Professional & Vocational. Dimension: 189 x 232 x 28. Weight in Grams: 912. . 2010. 1st Edition. Paperback. . . . . Books ship from the US and Ireland. Seller Inventory # V9780763784164
Stock Image
Microsoft Transact-SQL: The Definitive Guide
Published by
Jones and Bartlett Publishers, Inc, 2010
ISBN 10: 0763784168
ISBN 13: 9780763784164
New
Paperback / softback
Seller: THE SAINT BOOKSTORE, Southport, United Kingdom
Seller rating 5 out of 5 stars
Paperback / softback. Condition: New. New copy - Usually dispatched within 4 working days. Seller Inventory # B9780763784164
Buy New
£ 44.31
£ 20.05 shipping
Ships from United Kingdom to U.S.A.
Ships from United Kingdom to U.S.A.
Quantity: 1 available