Microsoft Transact-SQL: The Definitive Guide (Paperback)
  • Microsoft Transact-SQL: The Definitive Guide (Paperback)

Microsoft Transact-SQL: The Definitive Guide (Paperback)

£41.99
Paperback Published: 15/05/2010
  • We can order this

Usually despatched within 1 week

  • This item has been added to your basket

Check Marketplace availability

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.

Publisher: Jones and Bartlett Publishers, Inc
ISBN: 9780763784164

You may also be interested in...

Your review has been submitted successfully.

We would love to hear what you think of Waterstones. Why not review Waterstones on Trustpilot?


Review us on Trustpilot