T-SQL Querying, 1st edition

Published by Pearson (February 17, 2015) © 2015

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

Access details

  • Digital eBook
  • Instant access
  • Available online, offline and via apps
  • Accessible through the VitalSource Bookshelf

Features

  • In-depth look at T-SQL's internal architecture
  • Efficient top-down tuning methodology
  • Make highlights and notes
  • Search across the eBook content
Products list

Details

  • A print copy
  • Free shipping

Features

  • In-depth look at T-SQL's internal architecture
  • Efficient top-down tuning methodology
  • Assess algorithmic complexity
  • Data-analysis calculations

This product is expected to ship within 5-7 business days for Australian customers.

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. 
  • 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