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

Skip to content

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

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

Learn T-SQL Querying - Second Edition: A guide to developing efficient and
Stock photo: cover may vary

Learn T-SQL Querying - Second Edition: A guide to developing efficient and elegant T-SQL code Paperback - 2024

by Pedro Lopes

Add to wish list
  • New
New

Description

new.
Ask the seller a question Add to wish list
A$48.53
A$5.85 Delivery within USA
Standard delivery: 2 to 14 days
More delivery options
Ships from GreatBookPrices (Maryland, United States)
The BIBLIO Guarantee

Details

  • Title Learn T-SQL Querying - Second Edition: A guide to developing efficient and elegant T-SQL code
  • Author Pedro Lopes
  • Binding Paperback
  • Condition New
  • Pages 456
  • Volumes 1
  • Language ENG
  • Publisher Packt Publishing
  • Publication date 2024-02-29
  • Bookseller's Inventory # 47393041-n
  • 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 5

About GreatBookPrices Maryland, United States

Biblio member since 2024

Since 1991, we have worked every day to serve our customers with state-of-the-art technology and world class service. We are dedicated to providing customers around the world with the widest selection of books, DVDs, and CDs at the absolute lowest price.

Terms of Sale: 30 day return guarantee, with full refund including original shipping costs for up to 30 days after delivery if an item arrives misdescribed or damaged.

Browse books from GreatBookPrices

Reader reviews for Learn T-SQL Querying - Second Edition: A guide to developing 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-