Microsoft Transact-SQL: The Definitive Guide - Softcover

Jeffrey R. Garbus; Alvin Chang; Plamen Ratchev; Joe Celko

 
9780763784164: Microsoft Transact-SQL: The Definitive Guide
Softcover
ISBN 10: 0763784168 ISBN 13: 9780763784164
Publisher: Jones and Bartlett Publishers, Inc, 2010

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.

Publisher
Jones and Bartlett Publishers, Inc
Publication date
2010
Language
English
ISBN 10 
0763784168
ISBN 13 
9780763784164
Binding
Paperback
Edition number
1
Number of pages
512

Other Popular Editions of the Same Title

9781556223730: Microsoft Transact-SQL: The Definitive Guide

Featured Edition

ISBN 10:  1556223730 ISBN 13:  9781556223730
Publisher: Wordware Publishing Inc., 2005
Softcover