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
SQL SERVER - Database in RESTORING State for Long Time

SQL SERVER – Database in RESTORING State for Long Time

July 19, 2013
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore

Database stuck in restoring state after you restored every backup? Usually the last log was restored without RECOVERY. Here is how to bring it online.

Read More
A brass bell ringing above a shop door as it opens, a tally counter beside it

Change Data Capture or Change Tracking

July 18, 2013
Pinal Dave
SQL Tips and Tricks
Change Data Capture, ETL, SQL Server, SQL Server Agent, Transaction Log

Change data capture or change tracking serves different sync needs; compare captured detail, retention, cleanup, and operating cost before choosing.

Read More
Gouache painting of queued cards behind a wooden gate beside an hourglass and an output tray.

WAITFOR DELAY in SQL Server: SQL in Sixty Seconds #055

July 17, 2013
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Lock, SQL Scripts, SQL Wait Stats

WAITFOR DELAY pauses a SQL Server batch for a fixed amount of time. This episode shows the command, and the tests here measure how long it really waits, what it does to locks and workers, and where it stops being the right tool.

Read More
Gouache illustration for INNER JOIN: two matching oak corners use the same fitted joint construction.

INNER JOIN vs JOIN in SQL Server: Is There Any Difference?

July 16, 2013
Pinal Dave
SQL Tips and Tricks
SQL Joins, SQL Operator, SQL Scripts, SQL Server

INNER JOIN vs JOIN is a question about one optional keyword. The tests here show identical results, identical query and plan hashes, the one place where INNER is required, and the LEFT JOIN trap that really does change the rows.

Read More
An accordion with its bellows squeezed shut by a red strap, resting beside its large open case

ZSTD Backup Compression in SQL Server 2025

July 15, 2013
Pinal Dave
SQL Tips and Tricks
Compression, DBA, SQL Backup and Restore, SQL Server

Test ZSTD backup compression in SQL Server 2025, compare recorded sizes and algorithms, and check restores before changing defaults.

Read More
A crimped interlocking seam beside a flat seam with separate edges

Checking Which Connections Use TDS 8.0 and Strict Encryption

July 14, 2013
Pinal Dave
SQL Tips and Tricks
SQL Connection, SQL Server, SQL Server Encryption

TRUE in encrypt_option does not mean strict mode. Here is how to read the protocol value on your server and what to test before you enforce anything.

Read More
A stone causeway to a small island disappearing under the rising tide, a red flag at the shore.

Log Shipping to a Readable Standby: Restores vs Report Users

July 13, 2013
Pinal Dave
SQL Tips and Tricks
Log Shipping, SQL Backup and Restore, SQL High Availability, SQL Server

Configure a readable standby for log shipping, balance restore jobs with report users, and measure copy and restore delay.

Read More
A small proofing basket with a huge mass of dough spilling over its sides across a floured bakery bench.

Temp Table Statistics: Why a #Table Plan Goes Stale

July 12, 2013
Pinal Dave
SQL Performance
Execution Plan, SQL Performance, SQL Server, SQL Statistics, Temp Table

Inspect temp table statistics across procedure calls, compare estimates with loaded rows, and test targeted refresh and recompile fixes.

Read More
Gouache painting of a slate blue jacket on a wooden hanger with every button sewn on, and a dish holding one spare button, vermilion thread and a needle

DROP IF EXISTS and CREATE OR ALTER for Iterative Deployments

July 11, 2013
Pinal Dave
SQL Tips and Tricks
DevOps, SQL Server, SQL Stored Procedure

Run your deployment script twice and see what survives. A short demo shows why CREATE OR ALTER keeps permissions and drop and create does not.

Read More
Gouache painting of a book lying open on a wooden desk, thin grey copy sheets beneath its blank pages and one vermilion sheet at the edge

Change Data Capture Cost: Log, Storage and Cleanup Measured

July 10, 2013
Pinal Dave
SQL Performance
SQL Log, SQL Performance, SQL Scripts

Change Data Capture cost shows up in places a quick setup never checks. On SQL Server 2025, the same update wrote three times the log with CDC on, the log waited for the capture, and the change table grew to almost four times the table. Here is every number and the script that produced it.

Read More
Previous 1 … 334 335 336 337 338 339 340 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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