The books you love, the emails you want
Opt in by 25 May or you'll stop hearing from us
Take a detailed look at the internal architecture of T-SQL-and unveil the power of set-based querying-with comprehensive reference and advice from the experts. Database developers and administrators get best practices, sample databases, and code to master the intricacies of the programming language-solving complex problems with real-world solutions. Discover how to: * Understand logical and physical query processing * Apply a methodology to optimize query tuning * Solve relational division problems * Use CTEs and ranking functions to simplify and optimize solutions * Aggregate data with various techniques, including tiebreakers, pivoting, histograms, and grouping factors * Use the TOP option in a query to modify data * Query specialized data structures with recursive logic, materialized path, or nested sets solutions * PLUS-Improve your logic and get to the heart of querying problems with logic puzzles Get code and database samples on the Web
Publisher: Microsoft Press,U.S.
Weight: 1238 g
Dimensions: 235 x 187 x 40 mm
You may also be interested in...
Please sign in to write a review
Thank you for your reservation
Your order is now being processed and we have sent a confirmation email to you at
When will my order be ready to collect?
Call us on or send us an email at
Unfortunately there has been a problem with your order
Please try again or alternatively you can contact your chosen shop on or send us an email at