Common questions from newsgroups and forums

Posted on: March 3, 2009 4:54 pm

Search Engine Q&A #27: How does the storage engine find variable-length columns?

Posted on: March 1, 2009 10:42 am

Search Engine Q&A #26: Myths around causing corruption

Posted on: August 27, 2008 5:11 pm

Search Engine Q&A #25: Why isn’t my log backup the same size as my log?

Posted on: August 25, 2008 12:23 am

Search Engine Q&A #24: Why can’t the transaction log use instant initialization?

Posted on: August 20, 2008 7:47 pm

Search Engine Q&A #23: My transaction log is full – now what?

Posted on: August 14, 2008 3:05 pm

Search Engine Q&A #22: Can all page types be single-page restored?

Posted on: August 11, 2008 7:32 pm

Search Engine Q&A #21: File header pages, and file header corruption

Posted on: July 25, 2008 2:10 pm

Search Engine Q&A #20: Boot pages, and boot page corruption

Posted on: July 11, 2008 12:01 am

Search Engine Q&A #19: Misconceptions around index rebuilds (allocation, BULK_LOGGED mode, locking)

Posted on: June 8, 2008 5:12 pm

Search Engine Q&A #18: What’s the current uptime of SQL Server?

Posted on: April 17, 2008 1:27 am

Search Engine Q&A #17: Split a VLDB into filegroups or smaller databases for backups?

Posted on: March 13, 2008 5:41 pm

Search Engine Q&A #16: Concurrent log and full backups

Posted on: February 21, 2008 2:23 am

Search Engine Q&A #15: Mirrored backups

Posted on: February 5, 2008 5:39 pm

Search Engine Q&A #14: Beware 3rd party file-system drivers with DBCC CHECKDB

Posted on: February 4, 2008 6:36 am

Search Engine Q&A #13: Difference between database version and database compatibility level

Posted on: January 29, 2008 11:51 pm

The frustration of sweeping generalizations – follow on from Search Engine Q&A #12

Posted on: January 29, 2008 5:35 am

Search Engine Q&A #12: Should you create multiple files for a user DB on a multi-core box?

Posted on: January 29, 2008 2:10 am

Search Engine Q&A #11: How to design a global-ready database?

Posted on: January 28, 2008 8:33 am

Search Engine Q&A #10: Rebuilding Indexes and Updating Statistics

Posted on: January 27, 2008 12:01 am

Search Engine Q&A #9: How to update constraints?

Posted on: December 5, 2007 12:51 am

Search Engine Q&A #8: How can defragging an index break synchronous mirroring? And what happens?

Posted on: October 25, 2007 5:04 pm

Search Engine Q&A #7: Restoring from a backup file containing multiple database backups

Posted on: October 10, 2007 1:35 am

Search Engine Q&A #6: Using fn_dblog to tell if a transaction is contained in a backup

Posted on: October 6, 2007 1:00 am

Search Engine Q&A #5: Do multi-core CPUs perform better than single-core CPUs?

Posted on: October 5, 2007 7:43 pm

Search Engine Q&A #4: Using EMERGENCY mode to access a RECOVERY PENDING or SUSPECT database

Posted on: October 2, 2007 5:20 pm

Search Engine Q&A #3: Database mirroring failover types and partner timeouts

Posted on: October 1, 2007 11:31 pm

Search Engine Q&A #2: Moving a database while Database Mirroring is running

Posted on: September 28, 2007 3:27 pm

Search Engine Q&A #1: Running out of transaction log space

Posted on: September 24, 2007 12:35 am