COVID-19 update: Victoria update. Click for details.
Contact Us Need help? Contact us
Explore Departments
Departments

T-sql Querying

Itzik Ben-gan, Adam Machanic, Dejan Sarka and Kevin Farlee


  • Paperback
    $95.71
ISBN: 9780735685048
T-sql Querying
$95.71
Or pay later with
Ready to ship
From Sydney
Delivery
Check your delivery time: Your delivery location:
{{ SelectedArea.Suburb }}{{ SelectedArea.Country == 'AU' ? (', ' + SelectedArea.State) : '' }} ({{ SelectedArea.Postcode }}) change
  • {{ Area.Suburb }}{{ Area.Country == 'AU' ? (', ' + Area.State) : '' }} {{ Area.Postcode }}
  • Your area not listed?
    Try search by suburb and postcode.
{{ DeliveryOption.expectation }} - {{ DeliveryOption.door_time }}
{{ DeliveryOption.price | currencyCentsFree }}
from {{ DeliveryOption.price | currencyCentsFree }}
Option unavailable
If ordered {{ DeliveryOption.cutoff }}
{{ DeliveryOption.name }}
{{ DeliveryOption.special_message }}
 
 
!
An error occurred getting delivery options
Sorry about that, please try again later.
OTHER FORMATS:
  • Paperback
    $95.71
ISBN: 9780735685048

Publisher Description

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

Author Biography

-->Itzik Ben-Gan--> is a senior SQL Server instructor and consultant with 10 years of experience in networking, development, databases, and data warehousing. He is a popular columnist and contributing editor for "SQL Server Magazine". Highly certified, he is also a Microsoft Certified Trainer (MCT), a Microsoft Certified Systems Engineer + Internet (MCSE+1), a Microsoft Certified Solution Developer (MCSD), a Microsoft Certified Database Administrator (MCDBA), and a Microsoft SQL Server "Most Valuable Professional."

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

Long Description

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 optimizing response time and resource usage. Emphasizing 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 optimized bulk import tools Avoid date/time pitfalls that lead to buggy, poorly performing code Create optimized 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 About This Book For experienced T-SQL practitioners Includes coverage updated from Inside Microsoft SQL Server 2008 T-SQL Querying and Inside Microsoft SQL Server 2008 T-SQL Programming Valuable to developers, DBAs, BI professionals, and data scientists Covers many MCSE 70-464 and MCSA/MCSE 70-461 exam topics

Feature

Tackle the toughest set-based querying and query tuning problems of T-SQL! Move from procedural programming to the language of sets and logic Optimize query tuning with a top-down methodology Assess algorithmic complexity to predict performance Compare data-aggregation techniques, including new grouping sets

Product Details

Author
Itzik Ben-gan, Adam Machanic, Dejan Sarka, Kevin Farlee
Publisher
Microsoft Press,u.s.
Year
2015
ISBN-10
0735685045
ISBN-13
9780735685048
Format
Paperback
Media
Book
Pages
864
Publication Date
2015-03-06
Series
Developer Reference (Paperback)
Language
English
Illustrations
Yes
Country of Publication
United States
Short Title
T-SQL QUERYING
Audience
Professional and Scholarly