Most Recent Blog Posts

May 26, 2010

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
May 20, 2010

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
May 14, 2010

Why Isn’t the Mirroring Partner Timeout Working?7

I’ve read that I must increase the mirroring partner timeout when combining database mirroring and failover clustering. I tried a manual failover....More
Apr 30, 2010

Using Partial Database Availability for Targeted Restores1

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
Apr 27, 2010

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

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
Apr 22, 2010

Changing the Definition of a Clustered Index3

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
Apr 22, 2010

What Happens if I Drop a Clustered Index?4

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
Apr 01, 2010

Determining the Position of Search Arguments Within a Join6

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
Mar 29, 2010

Sizing Your Transaction Log2

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
Mar 29, 2010

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
Mar 26, 2010

Comparing Execution Plans3

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
Mar 23, 2010

What You Back Up Is What You Restore1

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

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