Paul S. Randal

CEO, SQLskills.com

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 by Paul S. Randal

missing blue puzzle piece
07/31/2012 - 10:58am

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
07/27/2012 - 2:12am

Is the recovery interval guaranteed?

The recovery interval is not guaranteed in any way—it’s simply a goal....More
blue computer keyboard
07/18/2012 - 1:31am

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
07/04/2012 - 12:06am

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
06/27/2012 - 8:46am

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
06/20/2012 - 3:16pm

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
06/19/2012 - 11:42am

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
06/14/2012 - 1:53am

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
06/08/2012 - 11:27am

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
05/29/2012 - 6:30am

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

Sponsored Introduction Continue on to (or wait seconds) ×