BIBLIO is the largest independent book marketplace in the world, with over 100 million books.

Skip to content

Learn T-SQL Querying: A guide to creating advanced, efficient and elegant T-SQL code

Learn T-SQL Querying: A guide to creating advanced, efficient and elegant T-SQL code

Learn T-SQL Querying: A guide to creating advanced, efficient and elegant T-SQL
Stock photo: cover may vary

Learn T-SQL Querying: A guide to creating advanced, efficient and elegant T-SQL code Paperback / softback - 2024

by Pam Lahoud

Add to wish list
  • New
  • Paperback
New

Description

Paperback / softback. New. Empower T-SQL developers with the skills to troubleshoot query performance issues, identify anti-patterns in their code and write efficient T-SQL queries Key Features An all-in-one guide to master the techniques of writing efficient T-SQL code Learn query optimization fundamentals, query analysis, and how query structure impacts performance Insightful solutions to detect, analyze, and tune query performance issues Book DescriptionTransact-SQL (T-SQL) is Microsoft’s proprietary extension to the SQL language used with Microsoft SQL Server and Azure SQL Database. This 2nd edition is for all data professionals who want to master the art of writing efficient T-SQL code in modern SQL Server versions, as well as Azure SQL Database. The book starts with query processing fundamentals to help you write solid, performant T-SQL queries. You will be introduced to the mechanics of the Query Optimizer. Later you will explore Query Execution Plans. It will help you analyze execution plans to gain insights into current performance and gauge whether a query is scalable. You will learn to build diagnostic queries using dynamic management views (DMVs) and dynamic management functions (DMFs) to unlock the secrets of T-SQL execution. Next, you will learn about indexing for T-SQL Performance. You will also learn about SQL Server built-in tools to shorten the time to address query performance and scalability issues. You will learn to implement various features such as Avoiding UDF pitfalls, Understanding Predicate SARGability, Query Store, and Query Tuning Assistant using hands-on examples. By the end of the book, you will be able to determine where query performance bottlenecks are, understand what anti-patterns may be in use, and how to avoid such pitfalls as we advance.What you will learn Identify opportunities to write well-formed T-SQL statements Get familiar with the Cardinality Estimator Create efficient indexes for your existing workloads Best practices for T-SQL querying Explore Query Execution DMVs Utilize the latest performance optimization features in SQL Server 2017, 2019, and 2022 Protect query performance during upgrades to newer versions of SQL Server Who this book is forThis book is for database administrators, database developers, data analysts, data scientists and T-SQL practitioners who want to master the art of writing efficient T-SQL code and troubleshooting query performance issues using practical examples. A basic understanding of T-SQL syntax, writing queries in SQL Server, and using the SQL Server Management Studio tool is helpful to get started.
Ask the seller a question Add to wish list
A$67.96
A$19.32 Delivery to USA
Standard delivery: 14 to 21 days
More delivery options
Ships from The Saint Bookstore (Merseyside, United Kingdom)
Biblio Top Seller
The BIBLIO Guarantee

Details

  • Title Learn T-SQL Querying: A guide to creating advanced, efficient and elegant T-SQL code
  • Author Pam Lahoud
  • Binding Paperback
  • Condition New
  • Pages 456
  • Volumes 1
  • Language ENG
  • Publisher Packt Publishing
  • Publication date 2024-02-29
  • Bookseller's Inventory # B9781837638994
  • ISBN 9781837638994 / 1837638993
  • Weight 1.71 lbs (0.78 kg)
  • Dimensions 9.25 x 7.5 x 0.92 in (23.50 x 19.05 x 2.34 cm)
  • Category Computers - Data Base Management
  • Quantity available 10

About The Saint Bookstore Merseyside, United Kingdom

Specialising in: Academic & Scholarly, Hard To Find Titles, Textbooks
Biblio member since 2018

The Saint Bookstore specialises in hard to find titles & also offers delivery worldwide for reasonable rates.

Terms of Sale: Refunds or Returns: A full refund of the price paid will be given if returned within 30 days in undamaged condition. If the product is faulty, we may send a replacement.

Browse books from The Saint Bookstore

Reader reviews for Learn T-SQL Querying: A guide to creating advanced, efficient and elegant T-SQL code

Write a review for this book

There are no reviews for this book yet. Be the first to write a review!

Your review will be anonymous unless you login or create an account first.

Overall rating
Remember: You’re rating the book as a work, not the seller or the condition of the specific copy you purchased!

Important Terms and Guidelines

  • Please focus on the book’s content and context. Also, add any personal comments as to how you enjoyed the book. Substantiate your likes and dislikes. You may make comparisons to other books.
  • Reviews must be at least 140 characters in length.
  • Please do not reveal critical plot elements.
  • This is not a help line. Contact customer support if you need help.
Your review must not include:
  • Obscenities, discriminatory language, or other insulting language not suitable for public domain
  • Advertisements, “spam” content, or references to other products, offers or websites.
  • Email addresses, URLs, phone numbers, physical addresses or other contact information.
  • Overly critical comments about other reviews or reviewers
  • Time-sensitive material (i.e. promotional tours, seminars, lectures, etc.)
  • Availability, price, or alternative ordering/shipping information

From the publisher

Troubleshoot query performance issues, identify anti-patterns in your code, and write efficient T-SQL queries with this guide for T-SQL developers

Key Features:

- A definitive guide to mastering the techniques of writing efficient T-SQL code

- Learn query optimization fundamentals, query analysis, and how query structure impacts performance

- Discover insightful solutions to detect, analyze, and tune query performance issues

- Purchase of the print or Kindle book includes a free PDF eBook

Book Description:

Data professionals seeking to excel in Transact-SQL for Microsoft SQL Server and Azure SQL Database often lack comprehensive resources. Learn T-SQL Querying second edition focuses on indexing queries and crafting elegant T-SQL code enabling data professionals gain mastery in modern SQL Server versions (2022) and Azure SQL Database. The book covers new topics like logical statement processing flow, data access using indexes, and best practices for tuning T-SQL queries.

Starting with query processing fundamentals, the book lays a foundation for writing performant T-SQL queries. You'll explore the mechanics of the Query Optimizer and Query Execution Plans, learning to analyze execution plans for insights into current performance and scalability. Using dynamic management views (DMVs) and dynamic management functions (DMFs), you'll build diagnostic queries. The book covers indexing and delves into SQL Server's built-in tools to expedite resolution of T-SQL query performance and scalability issues. Hands-on examples will guide you to avoid UDF pitfalls and understand features like predicate SARGability, Query Store, and Query Tuning Assistant.

By the end of this book, you'll have developed the ability to identify query performance bottlenecks, recognize anti-patterns, and avoid pitfalls

What You Will Learn:

- Identify opportunities to write well-formed T-SQL statements

- Familiarize yourself with the Cardinality Estimator for query optimization

- Create efficient indexes for your existing workloads

- Implement best practices for T-SQL querying

- Explore Query Execution Dynamic Management Views

- Utilize the latest performance optimization features in SQL Server 2017, 2019, and 2022

- Safeguard query performance during upgrades to newer versions of SQL Server

Who this book is for:

This book is for database administrators, database developers, data analysts, data scientists and T-SQL practitioners who want to master the art of writing efficient T-SQL code and troubleshooting query performance issues through practical examples. A basic understanding of T-SQL syntax, writing queries in SQL Server, and using the SQL Server Management Studio tool will be helpful to get started.

Table of Contents

- Understanding Query Processing

- Mechanics of the Query Optimizer

- Exploring Query Execution Plans

- Indexing for T-SQL Performance

- Writing Elegant T-SQL Queries

- Discovering T-SQL Anti-patterns in Depth

- Building diagnostic queries using DMVs and DMFs

- Building XEvent profiler traces

- Comparative analysis of Query Plans

- Tracking performance history with Query Store

- Troubleshooting Live Queries

- Managing optimizer changes with the Query Tuning Assistant

Please wait a moment while we load the requested page.

tracking-