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 line of small wooden carts waiting at a narrow hopper, the first one vermilion

Insert Workload Waits: WRITELOG and PAGELATCH_EX

May 2, 2020
Pinal Dave
SQL Performance
Best Practices, SQL Log, SQL Scripts, SQL Wait Stats, Testing

Insert workload waits come down to two names, WRITELOG and PAGELATCH_EX. This post runs 16 connections that insert one row at a time and reads their waits with a tested script. It explains what each wait means and where to look for a fix.

Read More
Gouache painting of a wooden spoon with a vermilion handle beside a big cream stand mixer

sqlcmd vs SSMS: How to Time the Same Loop Fairly

April 29, 2020
Pinal Dave
SQL Performance
Command Line, SQL Scripts, SQL Server Management Studio, sqlcmd, Testing

A sqlcmd vs SSMS timing is fair only when both tools run the same file. The clock must sit inside the script. This post times 10,000 inserts three ways with a log table, shows what changed and what didn’t, and lists the settings to match before you compare.

Read More
Gouache painting of a grey wheelbarrow of pumpkins beside a vermilion tractor on a farm track

oStress vs SSMS: What Each Tool Is Built to Measure

April 28, 2020
Pinal Dave
SQL Performance
Command Line, SQL Scripts, SQL Server Management Studio, Testing

oStress vs SSMS is not a race, because the tools measure different things. This post times 10,000 inserts in three ways with a clock inside the script, then shows how eight sessions finish the same work faster. It explains what a one-session loop really measures.

Read More
Gouache painting of a plank bridge over a brook loaded with sandbags, the top one vermilion

oStress Load Test: Run Many Sessions Against SQL Server

April 27, 2020
Pinal Dave
SQL Performance
Command Line, SQL Server, sqlcmd, Testing

An oStress load test runs one query from many connections at once, so you can watch SQL Server under a crowd. This post explains the main switches and runs a small first test with five connections. It also builds the same test with sqlcmd workers, for machines without oStress.

Read More
Gouache painting of a row of white beehives in a meadow, some open and some closed, one vermilion

Query Store Status for Every Database in SQL Server

April 24, 2020
Pinal Dave
SQL Performance
Query Store, SQL DMV, SQL Scripts, SQL Server Configuration

Query Store status for every database takes two queries, and the first is not enough. This post builds four demo databases, shows why the is_query_store_on flag hides frozen and read-only states, and runs one script that reads the real state of each database. It also shows what Query Store costs in memory.

Read More
A heavy door propped open by a red wedge that has quietly slid across the floor.

Forcing a Plan in Query Store and Checking That It Held

April 17, 2020
Pinal Dave
SQL Performance
Execution Plan, Query Store, SQL Performance, SQL Server

Use forcing a plan in Query Store with verified IDs, then audit force failures and runtime results every week so the fix stays useful.

Read More
A front door with two identical brass doorbells, one polished and gleaming, the other dull with a small cobweb.

Duplicate Statistics: Auto-Created Stats That Shadow Index Statistics

April 16, 2020
Pinal Dave
SQL Performance
DBA, SQL Index, SQL Server, SQL Statistics

Find duplicate statistics on index-leading columns, compare freshness and sampling, and generate cautious DROP STATISTICS candidates.

Read More
Previous 1 … 25 26 27 28 29 30 31 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

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