Academic book request
In order to decide if a book might be suitable for your course we know that you need to look at it in detail.
If you are an academic teaching a course of 12 or more students you can choose up to three complimentary inspection copies of textbooks that are applicable to the courses that you teach.
To request your inspection copies, please complete the form below.
Microsoft Transact-SQL: The Definitive GuideAuthor: Jeffrey Garbus
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.