Most Recent Blog Posts

missing blue puzzle piece
07/31/2012 - 10:58am

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
07/27/2012 - 2:12am

Is the recovery interval guaranteed?

The recovery interval is not guaranteed in any way—it’s simply a goal....More
blue computer keyboard
07/18/2012 - 1:31am

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
07/04/2012 - 12:06am

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
06/27/2012 - 8:46am

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
06/20/2012 - 3:16pm

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
06/19/2012 - 11:42am

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
06/14/2012 - 1:53am

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
06/08/2012 - 11:27am

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
05/29/2012 - 6:30am

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
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
Contributors

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'...

Kimberly L. Tripp

Kimberly L. Tripp has been working with SQL Server since 1990, and she’s worked as a consultant, trainer, speaker, and writer specializing in core SQL Server performance tuning and availability...
What's SQL Server Questions Answered?

Practical tips and answers to many of your questions about SQL Server including database management and performance issues.

Blog Archive

Sponsored Introduction Continue on to (or wait seconds) ×