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
Mixed wooden pieces in one shallow bowl beside three small bowls containing sorted matching pieces.

Normalisation in Plain Words, and When to Stop

February 24, 2021
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Understand normalisation through one order example, then decide when a reporting copy is worth the cost of keeping duplicated data consistent.

Read More
Gouache painting of a water wheel at a stream mill with a single vermilion bucket among gray ones

WHILE 1 = 1 Loop in T-SQL: Run Forever, Stop Safely

November 30, 2020
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Scripts, SQL Server

A WHILE 1 = 1 loop never ends on its own, so every one needs a planned exit. This post builds a once-a-second sampler with three ways out, a stop flag, a round limit and a time limit, then shows how to stop a loop from a second window and what the recursion limit does.

Read More
Gouache painting of two pottery benches, one cluttered with kept clay scraps and one swept clean beside a vermilion bucket

Recovery Model Insert Test: FULL vs SIMPLE Under Load

May 4, 2020
Pinal Dave
SQL Performance
Best Practices, SQL Backup and Restore, SQL Log, SQL Wait Stats, Testing

A recovery model insert test compares FULL and SIMPLE under a load of 16 connections. The log written is almost the same in both, and the elapsed time depends more on the server than on the model. The real difference is when the log can be reused, and this post shows that step by step.

Read More
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
A hand sets a plate on its embroidered outline on a half-set table, a red jug in the center.

Writing Rerunnable Deployment Scripts for Database Changes

May 1, 2020
Pinal Dave
SQL Tips and Tricks
Best Practices, DevOps, SQL Scripts, SQL Server

Write rerunnable deployment scripts with guarded schema changes, version records, and a dry run on a restored database copy.

Read More
Two strings of drying chillies by a window, one twice as long, a red needle on the sill.

Proving a Tuning Change Worked With Before and After Numbers

March 10, 2020
Pinal Dave
SQL Performance
Best Practices, Query Store, SQL Performance, SQL Server

Prove a tuning change with before and after numbers from Query Store for CPU, reads, duration, and comparable execution volume.

Read More
A boot mud scraper bearing fresh mud while clean ground surrounds it

Listing Objects Changed Since the Last Release With modify_date

February 25, 2020
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Performance, SQL Server

modify_date shows what changed after a release, but never what was dropped. Here is a small baseline trick that fills the gap.

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

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