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 in SQL Server Questions Answered view all

missing blue puzzle piece
Jul 31, 2012

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
Jul 27, 2012

Is the recovery interval guaranteed?

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

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
Jul 04, 2012

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
Jun 27, 2012

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
Jun 20, 2012

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
Jun 19, 2012

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
Jun 14, 2012

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
Jun 08, 2012

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
May 29, 2012

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) ×