Data & IT
Pocket
Microsoft Transact-SQL: The Definitive Guide
J Garbus • A Chang • P Ratchev • J Celko
819:-
Uppskattad leveranstid 2-7 arbetsdagar
Fri frakt för medlemmar vid köp för minst 249:-
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
- Format: Pocket/Paperback
- ISBN: 9780763784164
- Språk: Engelska
- Antal sidor: 512
- Utgivningsdatum: 2010-05-15
- Förlag: JONES AND BARTLETT