Most Recent Blog Posts

11/12/2010 - 12:15pm

Is SQL Server Up-Level Compatible?

Q: Why can’t I restore a database from SQL Server 2008 to a SQL Server 2005 instance? It doesn’t work even when I use the 90-compatibility mode. A:....More
11/07/2010 - 5:33pm

Should I Index My Foreign Key Columns?

SQL Server has never automatically created indexes on foreign keys....More
11/01/2010 - 8:08pm

A Safe Method for Moving a Database to a New Location

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
10/18/2010 - 8:52am

Why SQL Server Lets You Create Redundant Indexes

Why does SQL Server let me create the same (i.e., completely identical) index more than once?....More
10/12/2010 - 3:20pm

How Many Indexes Should I Create?

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
09/27/2010 - 12:47pm

How to choose a good index fill factor

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
09/21/2010 - 11:41pm

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
09/08/2010 - 9:55am

Is the Entire Clustering Key Duplicated in the Nonclustered Indexes?

Is the entire clustering key duplicated in the nonclustered indexes? What if I have a wide clustering key?....More
08/30/2010 - 10:54am

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

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
08/24/2010 - 9:10am

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
08/14/2010 - 1:40pm

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
08/06/2010 - 5:31pm

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
07/16/2010 - 4:40pm

Determining How Long It Takes for DBCC CHECKDB to Run

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
06/28/2010 - 8:20am

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

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
06/08/2010 - 1:35pm

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