This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Degree of Parallelism

SQL Server 2022 – Degree of Parallelism (DOP) Feedback for Optimize Query Performance

June 26, 2023
Pinal Dave
SQL Performance
Compatibility Level, MAXDOP, Parallel, Query Store, SQL CPU, SQL DMV, SQL Server 2022, SQL Server Configuration

SQL Server 2022 introduces a powerful new feature called Degree of Parallelism (DOP) feedback as part of the Intelligent Query Processing (IQP).

Read More
Locking

SQL SERVER – Locking, Blocking, and Deadlocking: Differences, Similarities, and Best Practices

June 22, 2023
Pinal Dave
SQL Performance
Deadlock, SQL Lock

Understanding SQL Server Deadlocks: A Beginner’s Guide, and after reading it, lots of people have asked me the difference between Locking, Blocking, and Deadlocking.

Read More
SQL Server Deadlocks

Understanding SQL Server Deadlocks: A Beginner’s Guide

June 19, 2023
Pinal Dave
SQL Performance
Deadlock, SQL DMV

Welcome to this introductory blog post on SQL Server Deadlocks. In this post, we’ll help you understand what deadlocks are, and how they occur.

Read More
A hand comparing a skein of green wool with one basket of green yarns in a shop full of colors

Exact Vector Search Cost: Filtering Before VECTOR_DISTANCE

June 8, 2023
Pinal Dave
SQL Performance
AI, SQL Index, SQL Performance, SQL Server

Measure exact vector search with VECTOR_DISTANCE, reduce candidates through indexed filters, and compare plans and measured IO.

Read More
Gouache painting of a basket with a heap of clothes beside neat folded stacks, a vermilion shirt on top

Heap or Clustered Index: When a Heap Table Is the Right Choice

June 7, 2023
Pinal Dave
SQL Performance
Clustered Index, SQL Data Storage, SQL Heap, SQL Index

The heap or clustered index choice changes the reads of every scan. The demos measure forwarded records in a heap, a range query on both kinds of table, and the size of a nonclustered index on a wide key, and says when a heap is the right choice.

Read More
A removable limiting rail bounds one assembly frame while the adjacent workstation remains separate.

Configuring Parallel Index Operations in SQL Server

May 31, 2023
Pinal Dave
SQL Performance
MAXDOP, SQL CPU, SQL Index

MAXDOP limits supported parallel index operations without changing unrelated instance settings. I choose the ceiling from the maintenance workload.

Read More
A hand pulling a lint filter packed thick with grey fluff from a tumble dryer full of damp towels.

Query Store Wait Stats: Why a Query Was Slow, Not Just That It Was

May 30, 2023
Pinal Dave
SQL Performance
Query Store, SQL Performance, SQL Server, SQL Wait Stats

Read Query Store wait stats by query, plan, interval, and category, then compare matched windows with execution counts and capture coverage.

Read More
Previous 1 … 7 8 9 10 11 12 13 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com