Microsoft Transact-SQL: the Definitive Guide: The Definitive Guide - Softcover

Garbus, Jeffrey

Softcover

ISBN 10: 0763784168 ISBN 13: 9780763784164

Verlag: Jones and Bartlett Publishers, Inc, 2010

Inhaltsangabe

According to industry studies, 7 -8 % 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 2 8 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.

Über diesen Titel

Über die Autorin bzw. den Autor

CEO, Soaring Eagle Consulting, Ltd., Tampa, Florida

Details zur Ausgabe

• Verlag: Jones and Bartlett Publishers, Inc
• Erscheinungsdatum: 2010
• Sprache: Englisch
• ISBN 10: 0763784168
• ISBN 13: 9780763784164
• Einband: Tapa blanda
• Auflage: 1
• Anzahl der Seiten: 516
• Kontakt zum Hersteller: Nicht verfügbar
• Verantwortliche Person: Nicht verfügbar