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
A fern frond pressed under glass on sun-print paper, its exact pale outline captured on the blue sheet.

Capturing Actual Execution Plans From a Script With SET STATISTICS XML

May 1, 2019
Pinal Dave
SQL Performance
Execution Plan, SQL Scripts, SQL Server, SQL XML

Capture actual plans with SET STATISTICS XML, save the extra result safely, inspect runtime fields, and compare last-known plan statistics.

Read More
Goats crowding one narrow gate in a stone wall while a second gate with a red latch stands open

Memory-Optimized tempdb Metadata: Turning It On and Checking It

April 25, 2019
Pinal Dave
SQL Performance
In-Memory OLTP, SQL Performance, SQL Server 2019, SQL TempDB

Diagnose memory-optimized tempdb metadata candidates, plan the required restart, verify activation, and monitor contention and memory.

Read More
Three plain hourglasses with different sand levels stand beside a closed notebook on a wooden desk.

The Handful of Counters That Actually Matter

April 24, 2019
Pinal Dave
SQL Performance
Best Practices, Database, SQL Scripts, SQL Server

Make SQL Server monitoring useful by relating waits, batch activity, memory indicators, and file latency to the same workload and observation window.

Read More
Several hands raising wine glasses over a dinner table, clinking every glass against each of the others.

Many-to-Many Merge Join and the Worktable in STATISTICS IO

April 18, 2019
Pinal Dave
SQL Performance
Execution Plan, SQL Joins, SQL Performance, SQL Server

Diagnose a many-to-many merge join and its worktable, verify true uniqueness, and compare join choices without changing legitimate matches.

Read More
A drinks tray with a red bowl of ready-cut lemon wedges beside an uncut lemon and knife.

Indexed Computed Columns: Speeding Up Code You Cannot Change

April 3, 2019
Pinal Dave
SQL Performance
Computed Column, SQL Index, SQL Performance, SQL Server

Use indexed computed columns to help fixed vendor queries on UPPER or CAST, while checking determinism and required SET options.

Read More
Three linked case clasps form a closed dependency cycle beside a separate release wedge.

SQL SERVER – A Brief History of Deadlock and Modern Approach of Resolution

April 2, 2019
Pinal Dave
SQL Performance
Deadlock, Quest, Webinar

A deadlock investigation needs the graph and cooperation between DBAs and developers. I distinguish a blocking wait from a cyclic dependency.

Read More
A roadside farm stall open for trade while a red crate of tomatoes is added at the back.

Async Statistics Updates: Stopping Queries From Stalling

April 1, 2019
Pinal Dave
SQL Performance
SQL Performance, SQL Server, SQL Statistics

Diagnose synchronous statistics refresh waits, enable async statistics updates, and judge when fresh estimates still matter more.

Read More
Previous 1 … 41 42 43 44 45 46 47 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

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