Paul S. Randal


Paul Randal worked on Microsoft's SQL Server team for nine years in development and management roles, writing many of the DBCC commands. Randal was ultimately responsible for SQL Server 2008's core storage engine. Randal now works as a consultant, trainer, speaker, and writer specializing in internals, maintenance, availability, and disaster recovery.

Posts in SQL Server Questions Answered view all

missing blue puzzle piece

Recovering a database with a missing transaction log

Usually when a database has open transactions and the server crashes, crash recovery will run on the affected database and roll back the open....More
Recovery road sign with arrow

Is the recovery interval guaranteed?

The recovery interval is not guaranteed in any way—it’s simply a goal....More
blue computer keyboard

Avoiding logging for user operations

Why does SQL Server insist on logging all operations, and is it likely that there will be an option to disable logging in future?....More
illustration of key and virtual lock

Locking and DBCC CHECKDB

From SQL Server 2000 onwards, DBCC CHECKDB runs online by default. Even in SQL Server 2000 though, DBCC CHECKDB still took Schema-Stability locks on....More
Geese running

Filtering out benign waits

The simple answer is that not all waits need to be analyzed when doing performance troubleshooting....More
multicolored ethernet network cables

Altering execution priority using Resource Governor

Most people know that Resource Governor allows you to specify CPU and memory limits when contention for these resources occurs, but it’s a little-....More
Beware wooden sign

Beware of trying to upgrade a database with a read-only filegroup

Upgrade does not work with read-only filegroups. If you try to take a SQL Server 2008 R2 database with a read-only filegroup and attach it to SQL....More
blue computer keyboard Delete key

How record DELETEs can cause index fragmentation

Record deletion can indeed cause fragmentation. There are two kinds of fragmentation described by SQL Server Books Online: logical fragmentation and....More
Speedy motorcycle racer

Why do TRUNCATE and DROP TABLE complete so fast?

In SQL Server 2000 SP3 the deferred drop mechanism was introduced. This works by unhooking the allocations for a table and placing them on the....More
Data word and numbers

Do log records ever move in the transaction log?

Why is it that sometimes when I try to shrink a transaction log file, the shrink fails? Why can’t SQL Server just move log records to the start of....More
What's SQL Server Questions Answered?

Practical tips and answers to many of your questions about SQL Server including database management and performance issues.

Sponsored Introduction Continue on to (or wait seconds) ×