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
Jan 06, 2012

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
Dec 28, 2011

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
Dec 21, 2011

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
Dec 15, 2011

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
Dec 07, 2011

Is it possible to run out of bigint values?

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

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
Oct 20, 2011

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
Sep 29, 2011

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
Sep 22, 2011

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
Sep 14, 2011

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