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
Parameter Sensitive

Parameter Sensitive Plan optimization in SQL Server 2022 – SQL in Sixty Seconds #200

May 16, 2023
Pinal Dave
SQL Video
Execution Plan, Parameter Sniffing, SQL in Sixty Seconds, SQL Performance

SQL Server 2022 introduces Parameter Sensitive Plan Optimization (PSPO), a feature that revolutionizes the performance of parameterized queries.

Read More
A sash window latch selecting one pane within a larger window frame

statement_start_offset: Showing the Exact Statement Running Now

February 10, 2023
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Performance, SQL Server

A stored procedure runs for forty minutes and you need the busy line. Here is how to pull it out of the batch text without the usual off-by-two mistakes.

Read More
An electrotype mold kept separately beside an impression made from it

Updatable Ledger Tables: Proving No One Quietly Changed a Row

January 25, 2023
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Performance, SQL Server

Update a row in a ledger table and the old version stays. Then verify the history with a digest, and break the digest to see what failure looks like.

Read More
Two frying pans on a stove, butter sizzling in the hot one and sitting solid in the cold one.

Cold Cache vs Warm Cache: Testing Query Speed Fairly

January 9, 2023
Pinal Dave
SQL Performance
SQL Cache, SQL Memory, SQL Performance, SQL Server, Testing

Compare cold cache and warm cache query tests using isolated buffer clearing, logical and physical reads, and controlled measurements.

Read More
A milking pail with two portions of fresh milk added beside a larger retained total

Turning Per-Second Counters Into Real Rates From DMVs

December 13, 2022
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Performance, SQL Server

That per-second counter on your dashboard is probably a running total. Here is how to turn it into a real rate with two samples.

Read More
A person walking through a maize field, peeling back one cob every few rows, a small red basket on the arm

Approximate Percentiles With APPROX_PERCENTILE_CONT

October 31, 2022
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Performance, SQL Server, SQL Server 2022

Use APPROX_PERCENTILE_CONT for large response-time summaries, compare exact percentiles, and interpret the documented rank error bound.

Read More
Two boards overlapping at a woodworking bench dog while another pair just touches

Finding Schedule Clashes: Overlapping Sessions per Attendee

October 26, 2022
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Performance, SQL Server

An attendee says two sessions run at the same time. Here is how to find every overlapping pair once, and why touching is not a clash.

Read More
Previous 1 2 3 4 5 6 7 8 … 50 Next
  • Books
  • Testimonials
  • Privacy Policy

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