Microsoft Transact-SQL: The Definitive Guide
Jeffrey GarbusBooks.org participates in affiliate programs including Bookshop.org and the Amazon Services LLC Associates Program. We may earn a commission from qualifying purchases made through links on this page, at no additional cost to you.
Overview
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.
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.
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.