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

computer keyboard key labeled backup
01/06/2012 - 2:29am

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
12/28/2011 - 3:28pm

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
12/21/2011 - 12:30pm

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
12/15/2011 - 9:59am

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
12/07/2011 - 1:32pm

Is it possible to run out of bigint values?

You can run out of bigints but it’s not practical that you will....More
12/01/2011 - 9:26am

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
10/20/2011 - 12:56pm

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
09/29/2011 - 10:43am

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
09/22/2011 - 11:18am

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
09/14/2011 - 2:20pm

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