Itzik Ben-Gan
  • Home
  • Books
  • T-SQL Courses
  • Resources
  • About
  • More
    • Home
    • Books
    • T-SQL Courses
    • Resources
    • About
Itzik Ben-Gan
  • Home
  • Books
  • T-SQL Courses
  • Resources
  • About

T-SQL Querying

By: Itzik Ben-Gan, Dejan Sarka, Adam Machanic, Kevin Farlee
Technical Editor: Alejandro Mesa
Publication Date: February 2015
ISBN-13: 978-0735685048
ISBN-10: 0735685045
864 pages









Introduction

Updating both Inside Microsoft SQL Server 2008: T-SQL Querying (Microsoft Press, 2009) and parts of Inside Microsoft SQL Server 2008: T-SQL Programming (Microsoft Press, 2009), this book gives database developers and administrators a detailed look at the internal architecture of T-SQL and a comprehensive programming reference. It includes coverage of SQL Server 2012 and 2014, but in many cases deals with areas that are not version-specific and will likely be relevant in future versions of SQL Server. Tackle the toughest set-based querying and query-tuning problems—guided by an author team with in-depth, inside knowledge of T-SQL. Deepen your understanding of architecture and internals—and learn practical approaches and advanced techniques to optimize your code’s performance. This book covers many unique techniques that were developed, improved, and polished by the authors over their many years of experience, providing highly efficient solutions for common challenges. There’s a deep focus on the performance and efficiency of the techniques and solutions covered. The book also emphasizes the need to have a correct understanding of the language and its underlying mathematical foundations. 

Table of Contents

Chapter 01: Logical Query Processing

Chapter 02: Query Tuning

Chapter 03: Multi-Table Queries

Chapter 04: Grouping, Pivoting and Windowing

Chapter 05: TOP and OFFSET-FETCH

Chapter 06: Data Modification

Chapter 07: Working with Date and Time

Chapter 08: T-SQL for BI Practitioners

Chapter 09: Programmable Objects

Chapter 10: In-Memory OLTP

Chapter 11: Graphs and Recursive Queries


Sample Content (pdf)

Download

Source Code - © You’re only authorized to download if you own a legal copy of the book (zip)

Download

View / Submit Corrections

Submit Errata

Order the book at:

Copyright © 2023 Itzik Ben-Gan - All Rights Reserved.

Powered by GoDaddy