You must be logged in to post a review.
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 Guide
Author: Jeffrey GarbusOVERVIEW
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.
Related Products
Our Reviews
Blog

Congratulations to our giveaway #winners!
@JamesStubley
@Allterrainteach
@JamieJohnson92
@Reneg_AdeO45
@woodsy1892
If you weren't so lucky this time, here's 30% off the Nancy Caroline's #Emergency #Care in the Streets eBook - limited time only! 😊📚
http://bit.ly/nancyebook
We're giving 5 lucky people the chance to win their own copy of Nancy Caroline's #Emergency #Care in the Streets! Like & RT this post, tagging @classprofession so we don't miss your entry, before midday tomorrow. Follow us too so we can DM you! 🥳 UK Only.
http://bit.ly/classtcs
Newsletter Sign Up
Get newsletter updates to receive recommended reads, deals and more.
Reviews
There are no reviews yet.