Most Recent Blog Posts

08/11/2011 - 3:29pm

Controlling MAXDOP of executing queries

Your savior on Enterprise Edition is resource governor in SQL Server 2008. With this you can define different buckets (called workload groups) that....More
08/03/2011 - 2:33pm

Rebalancing data across files in a filegroup

There is no easy way to rebalance data across new files in a filegroup. It has long been known that for some workloads you can get a performance....More
07/27/2011 - 3:50pm

Avoiding never-ending index maintenance

An index is rebuilt or reorganized (I’ll just use rebuild for the rest of this post) even though it has very low fragmentation. Why does this happen....More
07/21/2011 - 5:00pm

Breaking the chain

Question: I’m trying to perform a point-in-time restore but two of the log backups were not taken by the log backup job. Will I be able to use those....More
07/17/2011 - 1:21pm

The Curious Case of: the un-droppable transaction log file

Adding a second transaction log file temporarily is quite acceptable when the log file runs out of space. If the log cannot be cleared (usually by a....More
07/04/2011 - 12:28pm

Surprising memory usage with database snapshots

Although data file pages will not be copied into the database snapshot data files until they change, if a page from the source database is used in....More
06/22/2011 - 12:55pm

The Curious Case of: the empty heap table

Whenever a row is deleted in a SQL Server heap, if the page that the row is stored on becomes empty, the page cannot be deallocated from the table....More
06/19/2011 - 5:42am

The Curious Case of: the read-retry error

You should put a SQL Server Agent alert on message 825 so you know when it occurs, and if it does, investigate the integrity of the I/O subsystem....More
06/08/2011 - 6:20am

Troubleshooting Page Life Expectancy Drops

Page life expectancy is an instantaneous measure of how long (in seconds) a data file page is expected to remain in memory in the buffer pool (also....More
06/01/2011 - 4:05pm

The Unkillable DBCC CHECKDB

In the past I’ve noticed some very strange behavior when running ad-hoc consistency checks. If I interrupt DBCC CHECKDB, it sometimes hangs and the....More
05/26/2011 - 8:26am

Disappearing Database Corruptions

Every so often our system produces an 824 error and our weekly consistency-checking job fails. However, when I run DBCC CHECKDB during the day there....More
05/17/2011 - 10:55am

Does SQL Server have incremental data backups?

A true incremental data backup only backs up the portions of the data files that have changed since the last incremental data backup. SQL Server....More
05/12/2011 - 5:32pm

Forced parameterization–when should I use it?

If you analyze your plan cache and end up finding that you have a lot of “single-use plans” but that many of those statements are actually the same....More
05/05/2011 - 3:47pm

How to monitor checkpoints

The easiest way to see which database is doing a checkpoint is to use trace flags so that the checkpoint process writes to the error log what it’s....More
04/28/2011 - 9:47am

The Curious Case of: the expanding table records

For a table with fixed-width columns, normal DML operations should not cause the record to expand – except in the case where one of the snapshot....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) ×