Most Recent Blog Posts

Nov 07, 2010

Should I Index My Foreign Key Columns?

SQL Server has never automatically created indexes on foreign keys....More
Nov 01, 2010

A Safe Method for Moving a Database to a New Location5

I’ve just taken over a SQL Server system and found that the previous owner installed all the databases on the C drive, including the 800GB production....More
Oct 18, 2010

Why SQL Server Lets You Create Redundant Indexes5

Why does SQL Server let me create the same (i.e., completely identical) index more than once?....More
Oct 12, 2010

How Many Indexes Should I Create?1

You’ve frequently discussed what a good clustering key should be, as well as how indexes work. However, you haven’t told us how many indexes we....More
Sep 27, 2010

How to choose a good index fill factor6

An index fill factor instructs the Storage Engine to leave some free space in leaf-level index pages during index build or rebuild operations (note....More
Sep 21, 2010

Fragmentation from using snapshot isolation

By enabling snapshot isolation just before the data loading commences, and switching it off again after the data loading finishes, the locks held by....More
Sep 08, 2010

Is the Entire Clustering Key Duplicated in the Nonclustered Indexes?2

Is the entire clustering key duplicated in the nonclustered indexes? What if I have a wide clustering key?....More
Aug 30, 2010

Why Doesn’t SQL Server Use the RID for Lookups from a Nonclustered Index into a Clustered Table?1

Actually, that is almost how versions prior to SQL Server 7.0 worked. In prior versions (before 7.0) SQL Server used a volatile RID – which would....More
Aug 24, 2010

Which Replication Databases Can I Mirror?

We recently had some database corruption caused by a faulty drive, and I’d now like to add protection to some of our databases using database....More
Aug 14, 2010

Can Backup Checksums Be Used as a Substitute for DBCC CHECKDB?

I’m having trouble finding a time when I can run DBCC CHECKDB on my databases because of the resources it consumes. I’m using the CHECKSUM option on....More
Aug 06, 2010

Is It Possible to Run Out of Log Sequence Numbers?

I’ve been wondering about the algorithm for generating log sequence numbers for transaction log records, and I’m concerned that with a high enough....More
Jul 16, 2010

Determining How Long It Takes for DBCC CHECKDB to Run2

Estimating how long DBCC CHECKDB will take to run on a given database is very difficult to know because there are so many variables involved....More
Jun 28, 2010

Can I Restore My Enterprise Edition Database on All Editions of SQL Server?2

There’s no easy way to tell whether you have partitioning in a database without querying the storage metadata to see if any tables/indexes have....More
Jun 08, 2010

Avoiding Query Errors with Partial Database Availability

When using any kind of partitioning, you need to ensure that the queries you’re running attempt to access only the online portions of the database,....More
Jun 03, 2010

Is It a Bad Idea to Rebuild All Indexes Every Night?1

Many people have a simple index maintenance plan and are finding that as data volumes increase, and maintenance windows start to close or disappear,....More

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