Most Recent Blog Posts

04/11/2012 - 6:28pm

Enable backup compression by default?

The SQL community was really pleased when Microsoft listened to everyone’s feedback and made backup compression available in Standard Edition of SQL....More
04/03/2012 - 4:21pm

What about moving LOB data while keeping the table online?

Moving LOB data associated with a table isn't simple—even with the SQL Server 2012 ability to rebuild indexes that include LOB data as an online....More
illustration of data cube with red arrows indicating movement
03/21/2012 - 7:26pm

What about moving LOB data?

There are actually a couple of ways to move LOB data associated with a table. Let's tackle moving LOB data using OFFLINE operations....More
03/13/2012 - 2:59pm

Setting permissions on a database mirror database snapshot

The only way to access the data in a mirror database is to create a database snapshot on the mirror database and then have users connect to the....More
03/07/2012 - 9:22am

Do query plans take account of what data is in memory?

When the query optimizer is evaluating various plans as it narrows down the possible choices for the best plan it can come up with in a reasonable....More
table data on white piece of paper
02/27/2012 - 9:45am

How about Filtered Indexes instead of Partitioning?

Filtered indexes are an incredibly powerful feature (one of my favorites) so I don't want to dissuade you from using them. A table can be partitioned....More
computer keyboard Power Shift key
02/23/2012 - 5:20pm

Did SQL Server eliminate any partitions?

If SQL Server is accessing a table where you don’t think it should, then check these things....More
02/09/2012 - 12:49pm

Solutions to VLT concerns around statistics and maintenance!

Let's tackle why partitioned views can be a fantastic choice for partitioning large sets—even for new design....More
illustration of data with colorful numbers in background
02/02/2012 - 7:23pm

Partitioned Tables v. Partitioned Views–Why are they even still around?

Partitioning is CRITICAL for VLT. What is VLT? It’s about as descriptive as VLDB and it means very large table. Most people speak of VLDBs (very....More
01/29/2012 - 8:45pm

Why does using repair invalidate replication subscriptions?

Any time that the REPAIR_ALLOW_DATA_LOSS option of DBCC CHECKDB (hereafter just called 'repair') is used, you need to consider the effect on....More
01/09/2012 - 2:28am

Transaction log corruption and DBCC CHECKDB

The process for creating a database snapshot is to checkpoint the real database, and then essentially run crash-recovery on the real database, but....More
computer keyboard key labeled backup
01/06/2012 - 2:29am

Transaction log corruption and backups

Transaction log corruption is interesting because it doesn’t usually cause any problems apart from failed backups. However, that doesn’t mean it....More
12/28/2011 - 3:28pm

Where to store LOB data?

There are two kinds of data type for storing LOB data – true LOB data types that can store more than 8000 bytes and the limited data types that can....More
12/21/2011 - 12:30pm

The Curious Case of: the failed database mirroring failover

Anything connecting to SQL Server has to be architected to cope with connection failures that occur and reconnect so that failover works correctly....More
12/15/2011 - 9:59am

When scheduled maintenance jobs collide

H’ve started seeing a problem where periodically the scheduled DBCC job fails and I get 823 errors in the error log. I also see errors from the file....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) ×