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

05/23/2012 - 3:19pm

SUSPECT vs. RECOVERY_PENDING

From SQL Server 2005 onwards (when the metadata subsystem inside SQL Server was extensively rewritten), the database management portion of the....More
05/16/2012 - 2:43pm

Curious Case of the missing SOS_SCHEDULER_YIELD waits

Many of the monitoring scripts/tools for looking at wait statistics aggregate all the wait statistics and return the top 95% of all waits occurring,....More
05/09/2012 - 6:18am

Physical ordering of records in an index

Learn how how Microsoft SQL Server maintains the ordering of record storage in indexes including at what point the records get moved around on the....More
04/26/2012 - 11:12am

Is my master database really corrupt?

It’s becoming increasingly common these days for DBAs to want to offload consistency checking of production databases to a secondary server, so that....More
04/17/2012 - 10:29am

How to prevent table scans when searching LOB data?

If a SELECT has the LOB column in the WHERE clause then the query plan will involve a table scan – as you cannot create a nonclustered index over a....More
04/11/2012 - 6:28pm

Enable backup compression by default?

The SQL community was really pleased when Microsoft listened to everyone’s feedback and made backup compression available in Standard Edition of SQL....More
03/13/2012 - 2:59pm

Setting permissions on a database mirror database snapshot

The only way to access the data in a mirror database is to create a database snapshot on the mirror database and then have users connect to the....More
03/07/2012 - 9:22am

Do query plans take account of what data is in memory?

When the query optimizer is evaluating various plans as it narrows down the possible choices for the best plan it can come up with in a reasonable....More
01/29/2012 - 8:45pm

Why does using repair invalidate replication subscriptions?

Any time that the REPAIR_ALLOW_DATA_LOSS option of DBCC CHECKDB (hereafter just called 'repair') is used, you need to consider the effect on....More
01/09/2012 - 2:28am

Transaction log corruption and DBCC CHECKDB

The process for creating a database snapshot is to checkpoint the real database, and then essentially run crash-recovery on the real database, but....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) ×