Microsoft Transact-SQL: The Definitive GuideAuthor :
Paperback
Published : Friday 4 June 2010
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.
You may also like ...
![Product](https://abcbooksimages.s3.eu-west-1.amazonaws.com/sBookimagesFlat2020/9781493211821.jpg)
by
Hardback
28 Jan 2015
SAP (Systems, applications and products in databases)
€87.75
Extended stock – Dispatch 5-7 days
![Product](https://abcbooksimages.s3.eu-west-1.amazonaws.com/sBookimagesFlat2020/9780763784164.jpg)
by
Paperback
04 Jun 2010
Database software
€46.79
Extended stock – Dispatch 5-7 days
![Product](https://abcbooksimages.s3.eu-west-1.amazonaws.com/sBookimagesFlat2020/9780007524303.jpg)
by
Paperback
20 Jun 2013
Modern and contemporary fiction: general and literary
€11.69
Extended stock – Dispatch 5-7 days
![Product](https://abcbooksimages.s3.eu-west-1.amazonaws.com/sBookimagesFlat2020/9780007441303.jpg)
by
Paperback
12 Apr 2012
Modern and contemporary fiction: general and literary
€15.20
Extended stock – Dispatch 5-7 days
Reviews