Please note: In order to keep Hive up to date and provide users with the best features, we are no longer able to fully support Internet Explorer. The site is still available to you, however some sections of the site may appear broken. We would encourage you to move to a more modern browser like Firefox, Edge or Chrome in order to experience the site fully.

Supporting your high street Find out how »
Microsoft Transact-SQL: The Definitive Guide, Paperback / softback Book

Microsoft Transact-SQL: The Definitive Guide Paperback / softback

Paperback / softback

Out of stock

Description

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.

Information

  • Out of stock

  • Format:Paperback / softback
  • Pages:516 pages
  • Publisher:Jones and Bartlett Publishers, Inc
  • Publication Date:
  • Category:
  • ISBN:9780763784164
Save 8%

£39.99

£36.59

Out of stock
Add to Basket
Sign in to add to wishlist
 
Free Home Delivery

on all orders

 
Pick up orders

from local bookshops

Information

  • Out of stock

  • Format:Paperback / softback
  • Pages:516 pages
  • Publisher:Jones and Bartlett Publishers, Inc
  • Publication Date:
  • Category:
  • ISBN:9780763784164