Most Recent Blog Posts

12/07/2011 - 1:32pm

Is it possible to run out of bigint values?

You can run out of bigints but it’s not practical that you will....More
12/01/2011 - 9:26am

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
11/17/2011 - 8:01pm

What's a good use for a UNIQUE filtered index?

Learn more about SQL Server UNIQUE filtered indexes and a minor limitation you'll need to know about....More
11/11/2011 - 12:42pm

How many steps should the histogram have?

During the final phase of statistics creation (called Histogram consolidation), SQL Server goes through and looks at neighboring steps....More
11/06/2011 - 4:41pm

Why can't SQL Server update statistics on the fly?

SQL Server stores statistics in 3 parts: the statistics header, the density vector and the histogram. The statistics header has basic (but very....More
10/20/2011 - 12:56pm

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
10/13/2011 - 1:57pm

Viewing the Last Updated Date for Statistics

In SQL Server 2005, they separated the IDs for column-level statistics from nonclustered index IDs and created a catalog view to see them: sys.stats....More
10/07/2011 - 6:30pm

STATISTICS_NORECOMPUTE – When would anyone want to use it?

STATISTICS_NORECOMPUTE stops the database-wide auto-updating (auto update statistics) from updating the specific statistics for an index (or column-....More
09/29/2011 - 10:43am

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
09/22/2011 - 11:18am

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
09/14/2011 - 2:20pm

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
09/08/2011 - 2:39pm

Inconsistent analysis with clustered indexes?

Question: I know that SQL Server is prone to inconsistent analysis using the read committed isolation level, but I thought I could prevent that by....More
08/29/2011 - 12:46pm

Reasons not to configure automatic failover for database mirroring

There are a few reasons why you may choose not to configure automatic failover....More
08/25/2011 - 1:07pm

Why does a data backup include transaction log?

When a database backup is restored, the result must be a transactionally consistent database (i.e. with no uncommitted transactions or structural....More
08/19/2011 - 2:00pm

How to prevent enormous SQL Server error log files

The number of error logs is set to 6 by default, and a new one is created each time the server restarts. Old ones are renamed when a new one is....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) ×