Most Recent Blog Posts

Aug 11, 2011

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
Aug 03, 2011

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
Jul 27, 2011

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

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
Jul 17, 2011

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
Jul 04, 2011

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

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
Jun 19, 2011

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
Jun 08, 2011

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
Jun 01, 2011

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
May 26, 2011

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
May 17, 2011

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
May 12, 2011

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
May 05, 2011

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

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