T-SQL Querying, 1st edition

Published by Microsoft Press (March 6, 2015) © 2015

  • Itzik Ben-Gan
  • Adam Machanic
  • Dejan Sarka
  • Kevin Farlee
Products list

This product is expected to ship within 10-12 business days for New Zealand customers

Title overview

T-SQL insiders help you tackle your toughest queries and query-tuning problems

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.

Table of contents

  • Chapter 1: Logical query processing
  • Chapter 2: Query tuning
  • Chapter 3: Multi-table queries
  • Chapter 4: Grouping, pivoting, and windowing
  • Chapter 5: TOP and OFFSET-FETCH
  • Chapter 6: Data modification
  • Chapter 7: Working with date and time
  • Chapter 8: T-SQL for BI practitioners
  • Chapter 9: Programmable objects
  • Chapter 10: In-Memory OLTP
  • Chapter 11: Graphs and recursive queries
  • Index

Need help?Get in touch