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

computer keyboard key labeled backup

Transaction log corruption and backups

Transaction log corruption is interesting because it doesn’t usually cause any problems apart from failed backups. However, that doesn’t mean it....More

Where to store LOB data?

There are two kinds of data type for storing LOB data – true LOB data types that can store more than 8000 bytes and the limited data types that can....More

The Curious Case of: the failed database mirroring failover

Anything connecting to SQL Server has to be architected to cope with connection failures that occur and reconnect so that failover works correctly....More

When scheduled maintenance jobs collide

H’ve started seeing a problem where periodically the scheduled DBCC job fails and I get 823 errors in the error log. I also see errors from the file....More

Is it possible to run out of bigint values?

You can run out of bigints but it’s not practical that you will....More

Vendor-mandated regular database shrinking

Shrinking databases causes index fragmentation, consumes CPU and IO resources, and generates a lot of transaction log (which can cause problems for....More

Does using WITH CHECKSUM ensure a successful backup?

When the WITH CHECKSUM option is used for a backup, the backup process will test the page checksums that exist on the data file pages being backed up....More

Efficient index maintenance using database mirroring

This is a common problem that people encounter when moving a production database to be mirrored. Although many people conduct testing of workload....More
Database icons

How are single-page allocations tracked?

Question: I’ve been reading some information on how SQL Server keeps track of which parts of a data file are used by a particular object – IAM pages....More

Increase fan-out to reduce index depth

Generally speaking, to find a particular record at the leaf level of the index, the Storage Engine starts at the root of the index and navigates down....More

Sponsored Introduction Continue on to (or wait seconds) ×