Most Recent Blog Posts

06/03/2010 - 4:55pm

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

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
05/26/2010 - 7:56am

Isn’t the Clustering Key Redundant?

When you use the Database Tuning Advisor (DTA) or the missing index dynamic management views (DMVs), these tools sometimes suggest nonclustered....More
05/20/2010 - 7:31am

Where does that clustering key go?

I’ve heard that SQL Server stores the clustering key (the columns that define the clustered index) in the nonclustered indexes. Why is that? And is....More
05/14/2010 - 7:38am

Why Isn’t the Mirroring Partner Timeout Working?

I’ve read that I must increase the mirroring partner timeout when combining database mirroring and failover clustering. I tried a manual failover....More
04/30/2010 - 2:50pm

Using Partial Database Availability for Targeted Restores

Q: I have a large database that I’d like to restore on a development system pretty regularly, but I don’t want to restore all the data. Is there a....More
04/27/2010 - 4:10pm

Why is a Rolled-Back Transaction Causing My Differential Backup to be Large?

Q: I’m confused by some behavior I’ve noticed with differential backups. When I update a large portion of a table (say, 10GB), the next differential....More
04/22/2010 - 1:25pm

Changing the Definition of a Clustered Index

I’ve learned that my clustering key (i.e., the columns on which I defined my clustered index) should be unique, narrow, static, and ever-increasing....More
04/22/2010 - 1:04pm

What Happens if I Drop a Clustered Index?

When a clustered index is created, SQL Server will temporarily duplicate and sort the data from the heap into the clustered index key order (because....More
04/01/2010 - 8:56am

Determining the Position of Search Arguments Within a Join

When writing a join, I always wonder if I can improve performance by moving the search argument into the JOIN clause instead of placing it in the....More
03/29/2010 - 1:07pm

Sizing Your Transaction Log

I’ve read a lot of conflicting advice on the Internet regarding how large a database’s transaction log should be, ranging from very small to half the....More
03/29/2010 - 8:10am

What’s Reading My Transaction Log?

I have a fairly heavy update workload in my database, and I have transactional replication enabled. When I’m monitoring disk activity I’ve noticed....More
03/26/2010 - 10:54am

Comparing Execution Plans

I’ve noticed that when I run a query with the Display Estimated Execution Plan option enabled instead of the Include Actual Execution Plan option....More
03/23/2010 - 10:00pm

What You Back Up Is What You Restore

I'm trying to come up with a database maintenance plan that runs as fast as possible. I've been told that restoring a full backup will reorganize the....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) ×