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
Gouache painting of a small wooden toy train with a vermilion engine on a very long winding track across a tabletop

Long-Running Query for Demonstrations You Can Control

September 6, 2019
Pinal Dave
SQL Tips and Tricks
SQL Performance, SQL Scripts, SQL Training

A long-running query for demonstrations has to run long enough to watch and stop when you say. This post builds one from a counting table, shows how its run time grows with the row count and explains how to watch and stop it. It also compares it with WAITFOR DELAY.

Read More
Gouache painting: a row of different shaped wooden pegs and a board with matching holes, one peg that does not fit lying beside the board marked with a vermilion ribbon

In-Memory OLTP Migration Checklist: Which Features Block You

September 5, 2019
Pinal Dave
SQL Performance
In-Memory OLTP, SQL Migration, SQL Scripts, SQL Server Management Studio

An In-Memory OLTP migration checklist from SSMS lists the tables and procedures the engine will refuse. This post tests those refusals on SQL Server 2025, shows which old limits are gone, and adds a query that finds blockers in your own database.

Read More
Active parallel loom threads are inspected separately from preserved guides and worn tools.

SQL SERVER – Active Parallel Requests and Cached Parallel Query History

September 4, 2019
Pinal Dave
SQL Performance
Parallel, SQL CPU, SQL Scripts, SQL Server

I Identify parallel running requests separately from parallel queries recorded in the cache. Those lists answer different performance questions.

Read More
An already ordered line of containers travels along a conveyor

Do Stream Aggregate Operator Always Need Sort Operator? – Interview Question of the Week #240

September 1, 2019
Pinal Dave
SQL Interview Questions and Answers
Execution Plan, Parallel, SQL Operator, SQL Scripts, SQL Server

Question: Do Stream Aggregate Operator Always Need Sort Operator?

Answer: Absolutely No.Before I explain this question a bit more in detail.

Read More
Gouache painting of a row of fruit baskets, three covered and clasped and one open vermilion basket of peaches

READPAST Query Hint: Skip Locked Rows in SQL Server

August 31, 2019
Pinal Dave
SQL Tips and Tricks
Query Hint, SQL Lock, SQL Scripts, SQL Transactions

The READPAST query hint makes a read skip rows that another transaction has locked, instead of waiting for them. This post builds a five-seat demo, runs it in two windows and lists the cases where the hint does nothing. It also shows the work queue pattern that pairs READPAST with UPDLOCK.

Read More
Illustrated cover: Stream Aggregate vs Gather Streams

SQL SERVER – Is Stream Aggregate is Same as Gather Streams of Parallelism?

August 30, 2019
Pinal Dave
SQL Tips and Tricks
Execution Plan, Parallel, SQL CPU, SQL Operator, SQL Scripts, SQL Server

Is Stream Aggregate is Same as Gather Streams of Parallelism? – This was one of the brilliant questions I had received during my recent engagement.

Read More
Gouache painting of a wooden marble run with three blocked channels and a vermilion marble in the open one

ENABLE_PARALLEL_PLAN_PREFERENCE Limits: Rows Per Thread

August 29, 2019
Pinal Dave
SQL Tips and Tricks
Parallel, Query Hint, SQL CPU, SQL Scripts

The ENABLE_PARALLEL_PLAN_PREFERENCE limits are easy to miss: the hint can’t make every query parallel, and it can’t spread rows evenly over the threads. This post proves three limits from the last actual plan of demo queries, with the rows each thread processed and the reason a plan stays serial.

Read More
Previous 1 … 64 65 66 67 68 69 70 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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