Search icon Close icon
Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases now! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.

Change country

Modal Close icon
Country selected Country selected
country flag United States
Country selected
country flag United Kingdom
Country selected
country flag India
Country selected
country flag Germany
Country selected
country flag France
Country selected
country flag Canada
Country selected
country flag Russia
Country selected
country flag Spain
Country selected
country flag Brazil
Country selected
country flag Australia
Country selected
country flag Argentina
Country selected
country flag Austria
Country selected
country flag Belgium
Country selected
country flag Bulgaria
Country selected
country flag Chile
Country selected
country flag Colombia
Country selected
country flag Cyprus
Country selected
country flag Czechia
Country selected
country flag Denmark
Country selected
country flag Ecuador
Country selected
country flag Egypt
Country selected
country flag Estonia
Country selected
country flag Finland
Country selected
country flag Greece
Country selected
country flag Hungary
Country selected
country flag Indonesia
Country selected
country flag Ireland
Country selected
country flag Italy
Country selected
country flag Japan
Country selected
country flag Latvia
Country selected
country flag Lithuania
Country selected
country flag Luxembourg
Country selected
country flag Malaysia
Country selected
country flag Malta
Country selected
country flag Mexico
Country selected
country flag Netherlands
Country selected
country flag New Zealand
Country selected
country flag Norway
Country selected
country flag Philippines
Country selected
country flag Poland
Country selected
country flag Portugal
Country selected
country flag Romania
Country selected
country flag Singapore
Country selected
country flag Slovakia
Country selected
country flag Slovenia
Country selected
country flag South Africa
Country selected
country flag South Korea
Country selected
country flag Sweden
Country selected
country flag Switzerland
Country selected
country flag Taiwan
Country selected
country flag Thailand
Country selected
country flag Turkey
Country selected
country flag Ukraine
Country selected
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Home > Data > Database Administration > Learn T-SQL Querying
Learn T-SQL Querying
Learn T-SQL Querying

Learn T-SQL Querying: A guide to developing efficient and elegant T-SQL code

Arrow left icon
Profile Icon Pedro Lopes Profile Icon Lahoud
Arrow right icon
NZ$48.99 NZ$70.99
Full star icon Full star icon Full star icon Full star icon Half star icon 4.2 (9 Ratings)
eBook May 2019 484 pages 1st Edition
eBook
NZ$48.99 NZ$70.99
Paperback
NZ$87.99
Subscription
Free Trial
Arrow left icon
Profile Icon Pedro Lopes Profile Icon Lahoud
Arrow right icon
NZ$48.99 NZ$70.99
Full star icon Full star icon Full star icon Full star icon Half star icon 4.2 (9 Ratings)
eBook May 2019 484 pages 1st Edition
eBook
NZ$48.99 NZ$70.99
Paperback
NZ$87.99
Subscription
Free Trial
eBook
NZ$48.99 NZ$70.99
Paperback
NZ$87.99
Subscription
Free Trial

What do you get with eBook?

Product feature icon Instant access to your Digital eBook purchase
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Product feature icon AI Assistant (beta) to help accelerate your learning
Table of content icon View table of contents Preview book icon Preview Book

Learn T-SQL Querying

Section 1: Query Processing Fundamentals

To understand how to write solid, performant T-SQL, users should know how SQL Server runs T-SQL syntax to deliver the intended result sets in a scalable fashion. This section introduces the reader to concepts that are used throughout the remaining sections of this book to explain most patterns and anti-patterns, as well as mitigation strategies.

The following chapters are included in this section:

Left arrow icon

Page 1 of 1

Right arrow icon
Download code icon Download Code

Key benefits

  • Discover T-SQL functionalities and services that help you interact with relational databases
  • Understand the roles, tasks, and responsibilities of a T-SQL developer
  • Explore solutions for carrying out database querying tasks, database administration, and troubleshooting

Description

Transact-SQL (T-SQL) is Microsoft's proprietary extension to the SQL language used with Microsoft SQL Server and Azure SQL Database. This book will be a usefu to learning the art of writing efficient T-SQL code in modern SQL Server versions as well as the Azure SQL Database. The book will get you started with query processing fundamentals to help you write powerful, performant T-SQL queries. You will then focus on query execution plans and leverage them for troubleshooting. In later chapters, you will explain how to identify various T-SQL patterns and anti-patterns. This will help you analyze execution plans to gain insights into current performance, and determine whether or not a query is scalable. You will also build diagnostic queries using dynamic management views (DMVs) and dynamic management functions (DMFs) to address various challenges in T-SQL execution. Next, you will work with the built-in tools of SQL Server to shorten the time taken to address query performance and scalability issues. In the concluding chapters, this will guide you through implementing various features, such as Extended Events, Query Store, and Query Tuning Assistant, using hands-on examples. By the end of the book, you will have developed the skills to determine query performance bottlenecks, avoid pitfalls, and discover the anti-patterns in use.

Who is this book for?

This book is for database administrators, database developers, data analysts, data scientists, and T-SQL practitioners who want to get started with writing T-SQL code and troubleshooting query performance issues with the help of practical examples. Previous knowledge of T-SQL querying is not required to get started with this book.

What you will learn

  • Use Query Store to understand and easily change query performance
  • Recognize and eliminate bottlenecks that lead to slow performance
  • Deploy quick fixes and long-term solutions to improve query performance
  • Implement best practices to minimize performance risk using T-SQL
  • Achieve optimal performance by ensuring careful query and index design
  • Use the latest performance optimization features in SQL Server 2017 and SQL Server 2019
  • Protect query performance during upgrades to newer versions of SQL Server

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : May 03, 2019
Length: 484 pages
Edition : 1st
Language : English
ISBN-13 : 9781789342970
Vendor :
Microsoft
Category :
Data
Languages :
SQL
Concepts :
Database Administration

What do you get with eBook?

Product feature icon Instant access to your Digital eBook purchase
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Product feature icon AI Assistant (beta) to help accelerate your learning

Product Details

Publication date : May 03, 2019
Length: 484 pages
Edition : 1st
Language : English
ISBN-13 : 9781789342970
Vendor :
Microsoft
Category :
Data
Languages :
SQL
Concepts :
Database Administration

Packt Subscriptions

See our plans and pricing
Modal Close icon
$19.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
START FREE TRIAL
BUY NOW
$199.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just NZ$7 each
Feature tick icon Exclusive print discounts
START FREE TRIAL
BUY NOW
$279.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just NZ$7 each
Feature tick icon Exclusive print discounts
START FREE TRIAL
BUY NOW

Frequently bought together

SQL Server 2017 Developer???s Guide
SQL Server 2017 Developer???s Guide
Read more
Mar 2018 816 pages
Full star icon 3.6 (5)
eBook
eBook
  • eBook eBook NZ$49.99
  • Paperback Paperback NZ$89.99
NZ$49.99 NZ$71.99
NZ$89.99
Learn T-SQL Querying
Learn T-SQL Querying
Read more
May 2019 484 pages
Full star icon 4.2 (9)
eBook
eBook
  • eBook eBook NZ$48.99
  • Paperback Paperback NZ$87.99
NZ$48.99 NZ$70.99
NZ$87.99
SQL for Data Analytics
SQL for Data Analytics
Read more
Aug 2019 386 pages
Full star icon 3.5 (35)
eBook
eBook
  • eBook eBook NZ$64.99
  • Paperback Paperback NZ$116.99
NZ$64.99 NZ$93.99
NZ$116.99
Stars icon
Total NZ$ 294.97
SQL Server 2017 Developer???s Guide
NZ$89.99
Learn T-SQL Querying
NZ$87.99
SQL for Data Analytics
NZ$116.99
Total NZ$ 294.97 Stars icon

Table of Contents

17 Chapters
Section 1: Query Processing Fundamentals Chevron down icon Chevron up icon
Section 1: Query Processing Fundamentals
Anatomy of a Query Chevron down icon Chevron up icon
Anatomy of a Query
Building blocks of a T-SQL statement
Logical statement processing flow
Summary
Understanding Query Processing Chevron down icon Chevron up icon
Understanding Query Processing
Query compilation essentials
Query optimization essentials
Query execution essentials
Plan caching and reuse
The importance of parameters
Summary
Mechanics of the Query Optimizer Chevron down icon Chevron up icon
Mechanics of the Query Optimizer
Introducing the Cardinality Estimator
Understanding the query optimization workflow
Summary
Section 2: Dos and Donts of T-SQL Chevron down icon Chevron up icon
Section 2: Dos and Donts of T-SQL
Exploring Query Execution Plans Chevron down icon Chevron up icon
Exploring Query Execution Plans
Accessing a query plan
Navigating a query plan
Query plan operators of interest
Query plan properties of interest
Summary
Writing Elegant T-SQL Queries Chevron down icon Chevron up icon
Writing Elegant T-SQL Queries
Understanding predicate SARGability
Basic index guidelines
Best practices for T-SQL querying
Summary
Easily-Identified T-SQL Anti-Patterns Chevron down icon Chevron up icon
Easily-Identified T-SQL Anti-Patterns
The perils of SELECT *
Functions in our predicate
Deconstructing table-valued functions
Complex expressions
Optimizing OR logic
NULL means unknown
Fuzzy string matching
Inequality logic
EXECUTE versus sp_executesql
Composable logic
Summary
Discovering T-SQL Anti-Patterns in Depth Chevron down icon Chevron up icon
Discovering T-SQL Anti-Patterns in Depth
Implicit conversions
Avoiding unnecessary sort operations
Avoiding UDF pitfalls
Avoiding unnecessary overhead with stored procedures
Pitfalls of complex views
Pitfalls of correlated sub-queries
Properly storing intermediate results
Summary
Section 3: Assemble Your Query Troubleshooting Toolbox Chevron down icon Chevron up icon
Section 3: Assemble Your Query Troubleshooting Toolbox
Building Diagnostic Queries Using DMVs and DMFs Chevron down icon Chevron up icon
Building Diagnostic Queries Using DMVs and DMFs
Introducing Dynamic Management Views
Exploring query execution DMVs
Exploring query plan cache DMVs
Troubleshooting common scenarios with DMV queries
Summary
Building XEvent Profiler Traces Chevron down icon Chevron up icon
Building XEvent Profiler Traces
Introducing Extended Events
SQL Server Profiler – deprecated but not forgotten
Getting up and running with XEvent Profiler
Remote collection with PSSDiag and SQLDiag
Analyzing traces with RML Utilities
Summary
Comparative Analysis of Query Plans Chevron down icon Chevron up icon
Comparative Analysis of Query Plans
Query Plan Comparison
Query Plan Analyzer
Summary
Tracking Performance History with Query Store Chevron down icon Chevron up icon
Tracking Performance History with Query Store
The Query Store
Tracking expensive queries
Fixing regressed queries
Summary
Troubleshooting Live Queries Chevron down icon Chevron up icon
Troubleshooting Live Queries
Using Live Query Statistics
Understanding the need for Lightweight Profiling
Activity Monitor gets a new life
Summary
Managing Optimizer Changes with the Query Tuning Assistant Chevron down icon Chevron up icon
Managing Optimizer Changes with the Query Tuning Assistant
Understanding where QTA is needed
Understanding QTA fundamentals
Exploring the QTA workflow
Summary
Other Books You May Enjoy Chevron down icon Chevron up icon
Other Books You May Enjoy
Leave a review - let other readers know what you think

Recommendations for you

Left arrow icon
Python Machine Learning By Example
Python Machine Learning By Example
Read more
Jul 2024 518 pages
Full star icon 4.9 (8)
eBook
eBook
  • eBook eBook NZ$36.99
  • Paperback Paperback NZ$46.99
NZ$36.99 NZ$53.99
NZ$46.99 NZ$67.99
Building AI Applications with OpenAI APIs
Building AI Applications with OpenAI APIs
Read more
Oct 2024 252 pages
eBook
eBook
  • eBook eBook NZ$31.99
  • Paperback Paperback NZ$58.99
NZ$31.99 NZ$46.99
NZ$58.99
Unlocking Data with Generative AI and RAG
Unlocking Data with Generative AI and RAG
Read more
Sep 2024 346 pages
eBook
eBook
  • eBook eBook NZ$31.99
  • Paperback Paperback NZ$40.99
NZ$31.99 NZ$46.99
NZ$40.99 NZ$58.99
Building LLM Powered Applications
Building LLM Powered Applications
Read more
May 2024 342 pages
Full star icon 4.2 (22)
eBook
eBook
  • eBook eBook NZ$40.99
  • Paperback Paperback NZ$50.99
NZ$40.99 NZ$58.99
NZ$50.99 NZ$73.99
RAG-Driven Generative AI
RAG-Driven Generative AI
Read more
Sep 2024 334 pages
Full star icon 4.5 (13)
eBook
eBook
  • eBook eBook NZ$35.99
  • Paperback Paperback NZ$64.99
NZ$35.99 NZ$51.99
NZ$64.99
Machine Learning with PyTorch and Scikit-Learn
Machine Learning with PyTorch and Scikit-Learn
Read more
Feb 2022 774 pages
Full star icon 4.4 (95)
eBook
eBook
  • eBook eBook NZ$44.99
  • Paperback Paperback NZ$80.99
NZ$44.99 NZ$64.99
NZ$80.99
Python for Algorithmic Trading Cookbook
Python for Algorithmic Trading Cookbook
Read more
Aug 2024 404 pages
Full star icon 4.6 (15)
eBook
eBook
  • eBook eBook NZ$48.99
  • Paperback Paperback NZ$60.99
NZ$48.99 NZ$70.99
NZ$60.99 NZ$87.99
Microsoft Power BI - The Complete Masterclass [2023 EDITION]
Microsoft Power BI - The Complete Masterclass [2023 EDITION]
Read more
Jan 2023 14hrs 31mins
Video
Video
  • Video Video NZ$160.99
NZ$160.99
Principles of Data Science
Principles of Data Science
Read more
Jan 2024 326 pages
Full star icon 4.8 (4)
eBook
eBook
  • eBook eBook NZ$31.99
  • Paperback Paperback NZ$40.99
NZ$31.99 NZ$46.99
NZ$40.99 NZ$58.99
Mastering NLP from Foundations to LLMs
Mastering NLP from Foundations to LLMs
Read more
Apr 2024 340 pages
Full star icon 4.9 (24)
eBook
eBook
  • eBook eBook NZ$42.99
  • Paperback Paperback NZ$53.99
NZ$42.99 NZ$61.99
NZ$53.99 NZ$77.99
Right arrow icon

Customer reviews

Most Recent
  • Top Reviews
  • Most Recent
Rating distribution
Full star icon Full star icon Full star icon Full star icon Half star icon 4.2
(9 Ratings)
5 star 55.6%
4 star 33.3%
3 star 0%
2 star 0%
1 star 11.1%
Filter icon Filter
Most Recent
  • Top Reviews
  • Most Recent

Filter reviews by

Shibin Abraham Jan 30, 2024
Full star icon Full star icon Full star icon Full star icon Empty star icon 4
Good book. Got what I was expecting.
Amazon Verified review Amazon
Alexander Stark Dec 11, 2023
Full star icon Full star icon Full star icon Full star icon Empty star icon 4
Vielleicht ist das Buch super. Ich habe ein Buch gesucht das einem hilft gute T-SQL Queries zu schreiben. Das auf Fallstricke usw. hinweist und einem Wege aufzeigt wie man möglichst optimale Queries schreibt. Bisher ist das Buch sehr administrativ, es wird viel über SQL Server Versionen geschrieben und Exekution plans. Das mag alles ganz interessant und vielleicht auch zielführend sein. Etwas mehr SQL-Statments und daran erklären was darunter gut bzw. schlecht ist, fände ich besser.Stored Procedures werden nur kurz erwähnt.
Amazon Verified review Amazon
Joe Chacon Mar 14, 2023
Full star icon Full star icon Full star icon Full star icon Empty star icon 4
I am still working through the chapters of this books, but I will say just within the first 4 chapters I've learned how to investigate bottlenecks in my Stored Procedures, and I've learned how to dissect the Query Execution Plan.This book jumps right into it, occasionally can be difficult to follow but if you're willing to spend time looking up terms that are not defined and that you're not familiar with, this will be a great asset to have in your book shelf.
Amazon Verified review Amazon
Sanjeeva Jul 14, 2021
Full star icon Empty star icon Empty star icon Empty star icon Empty star icon 1
YouTube videos will cover more topics than this book. Don’t waste your money.
Amazon Verified review Amazon
David Mar 19, 2020
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Fantastic book, written by part of the SQL Server team. This covers more than just writing tSql queries; it provides a real insight into how the product processes your queries and why.
Amazon Verified review Amazon

People who bought this also bought

Left arrow icon
Machine Learning Engineering with Python
Machine Learning Engineering with Python
Read more
Aug 2023 462 pages
Full star icon 4.6 (36)
eBook
eBook
  • eBook eBook NZ$40.99
  • Paperback Paperback NZ$73.99
NZ$40.99 NZ$58.99
NZ$73.99
Deep Learning with TensorFlow and Keras – 3rd edition
Deep Learning with TensorFlow and Keras – 3rd edition
Read more
Oct 2022 698 pages
Full star icon 4.6 (45)
eBook
eBook
  • eBook eBook NZ$40.99
  • Paperback Paperback NZ$73.99
NZ$40.99 NZ$58.99
NZ$73.99
Modern Generative AI with ChatGPT and OpenAI Models
Modern Generative AI with ChatGPT and OpenAI Models
Read more
May 2023 286 pages
Full star icon 4.2 (34)
eBook
eBook
  • eBook eBook NZ$40.99
  • Paperback Paperback NZ$73.99
NZ$40.99 NZ$58.99
NZ$73.99
Generative AI with LangChain
Generative AI with LangChain
Read more
Dec 2023 368 pages
Full star icon 4 (34)
eBook
eBook
  • eBook eBook NZ$40.99
  • Paperback Paperback NZ$73.99
NZ$40.99 NZ$58.99
NZ$73.99
Causal Inference and Discovery in Python
Causal Inference and Discovery in Python
Read more
May 2023 456 pages
Full star icon 4.5 (49)
eBook
eBook
  • eBook eBook NZ$31.99
  • Paperback Paperback NZ$40.99
NZ$31.99 NZ$46.99
NZ$40.99 NZ$58.99
Right arrow icon

About the authors

Left arrow icon
Profile icon Pedro Lopes
Pedro Lopes
LinkedIn icon Github icon
Pedro Lopes is a Program Manager in the Database Systems group, based in Redmond, WA, USA. He has over 19 years of industry experience and has been with Microsoft for 9 years. He is currently responsible for program management of Database Engine features for in-market and vNext versions of SQL Server, with a special focus on the Relational Engine. He has extensive experience with query performance troubleshooting and is a regular speaker at numerous conferences such as SQLBits, PASS Summit, SQLIntersection, Microsoft Ignite, and Microsoft Build. He blogs about SQL on the SQL Server Team blog. He has authored several tools in the Tiger toolbox on GitHub: AdaptiveIndexDefrag maintenance solution, BPCheck, and usp_WhatsUp.
Read more
See other products by Pedro Lopes
Profile icon Lahoud
Lahoud
LinkedIn icon Github icon
Pam Lahoud is a Program Manager in the Database Systems group, based in Redmond, WA, USA. She has been with Microsoft for 13 years and is currently responsible for program management of Database Engine features for in-market and vNext versions of SQL Server, with a special focus on the Storage Engine area. She is passionate about SQL Server performance and has focused on performance tuning and optimization, particularly from the developer's perspective, throughout her career. She is a SQL Server 2008 Microsoft Certified Master (MCM) with over 20 years of experience working with SQL Server.
Read more
See other products by Lahoud
Right arrow icon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

How do I buy and download an eBook? Chevron down icon Chevron up icon

Where there is an eBook version of a title available, you can buy it from the book details for that title. Add either the standalone eBook or the eBook and print book bundle to your shopping cart. Your eBook will show in your cart as a product on its own. After completing checkout and payment in the normal way, you will receive your receipt on the screen containing a link to a personalised PDF download file. This link will remain active for 30 days. You can download backup copies of the file by logging in to your account at any time.

If you already have Adobe reader installed, then clicking on the link will download and open the PDF file directly. If you don't, then save the PDF file on your machine and download the Reader to view it.

Please Note: Packt eBooks are non-returnable and non-refundable.

Packt eBook and Licensing When you buy an eBook from Packt Publishing, completing your purchase means you accept the terms of our licence agreement. Please read the full text of the agreement. In it we have tried to balance the need for the ebook to be usable for you the reader with our needs to protect the rights of us as Publishers and of our authors. In summary, the agreement says:

  • You may make copies of your eBook for your own use onto any machine
  • You may not pass copies of the eBook on to anyone else
How can I make a purchase on your website? Chevron down icon Chevron up icon

If you want to purchase a video course, eBook or Bundle (Print+eBook) please follow below steps:

  1. Register on our website using your email address and the password.
  2. Search for the title by name or ISBN using the search option.
  3. Select the title you want to purchase.
  4. Choose the format you wish to purchase the title in; if you order the Print Book, you get a free eBook copy of the same title. 
  5. Proceed with the checkout process (payment to be made using Credit Card, Debit Cart, or PayPal)
Where can I access support around an eBook? Chevron down icon Chevron up icon
  • If you experience a problem with using or installing Adobe Reader, the contact Adobe directly.
  • To view the errata for the book, see www.packtpub.com/support and view the pages for the title you have.
  • To view your account details or to download a new copy of the book go to www.packtpub.com/account
  • To contact us directly if a problem is not resolved, use www.packtpub.com/contact-us
What eBook formats do Packt support? Chevron down icon Chevron up icon

Our eBooks are currently available in a variety of formats such as PDF and ePubs. In the future, this may well change with trends and development in technology, but please note that our PDFs are not Adobe eBook Reader format, which has greater restrictions on security.

You will need to use Adobe Reader v9 or later in order to read Packt's PDF eBooks.

What are the benefits of eBooks? Chevron down icon Chevron up icon
  • You can get the information you need immediately
  • You can easily take them with you on a laptop
  • You can download them an unlimited number of times
  • You can print them out
  • They are copy-paste enabled
  • They are searchable
  • There is no password protection
  • They are lower price than print
  • They save resources and space
What is an eBook? Chevron down icon Chevron up icon

Packt eBooks are a complete electronic version of the print edition, available in PDF and ePub formats. Every piece of content down to the page numbering is the same. Because we save the costs of printing and shipping the book to you, we are able to offer eBooks at a lower cost than print editions.

When you have purchased an eBook, simply login to your account and click on the link in Your Download Area. We recommend you saving the file to your hard drive before opening it.

For optimal viewing of our eBooks, we recommend you download and install the free Adobe Reader version 9.