Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQL’s internal architecture and offer advanced practical techniques for optimising response time and resource usage. Emphasising a correct understanding of the language and its foundations, the authors present unique solutions they have spent years developing and refining. All code and techniques are fully updated to reflect new T-SQL enhancements in Microsoft SQL Server 2014 and SQL Server 2012.

Write faster, more efficient T-SQL code:

• Move from procedural programming to the language of sets and logic
• Master an efficient top-down tuning methodology
• Assess algorithmic complexity to predict performance
• Compare data aggregation techniques, including new grouping sets
• Efficiently perform data-analysis calculations
• Make the most of T-SQL’s optimised bulk import tools
• Avoid date/time pitfalls that lead to buggy, poorly performing code
• Create optimised BI statistical queries without additional software
• Use programmable objects to accelerate queries
• Unlock major performance improvements with In-Memory OLTP
• Master useful and elegant approaches to manipulating graphs

The full text downloaded to your computer

With eBooks you can:

• search for key concepts, words and phrases
• make highlights and notes as you study
• share your notes with friends

eBooks are downloaded to your computer and accessible either offline through the Bookshelf (available as a free download), available online and also via the iPad and Android apps.

Upon purchase, you will receive via email the code and instructions on how to access this product.

Time limit

The eBooks products do not have an expiry date. You will continue to access your digital ebook products whilst you have your Bookshelf installed.