Academic book request
Inspection copies are available to lecturers considering books for courses. If you teach a relevant course of 12 or more students, please complete the form below with the details. We also kindly request that you provide feedback on any textbook you receive within 60 days of receipt.
Please note that outside of the UK, we can only provide eBooks. All requests are subject to our approval, further details regarding T&Cs may be found on our website.
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.