Most Recent Blog Posts

Apr 11, 2012

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
Apr 03, 2012

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
Mar 21, 2012

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
Mar 13, 2012

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
Mar 07, 2012

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
Feb 27, 2012

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
Feb 23, 2012

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
Feb 09, 2012

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
Feb 02, 2012

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
Jan 29, 2012

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
Jan 09, 2012

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
Jan 06, 2012

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
Dec 28, 2011

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
Dec 21, 2011

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
Dec 15, 2011

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