Beware of advice from 3rd-party tools around dropping indexes

Posted on: April 4, 2011 1:12 pm

A SQL Server DBA myth a day: (30/30) backup myths

Posted on: April 30, 2010 9:19 am

Why you should not shrink your data files

Posted on: June 24, 2009 10:02 am

Misconceptions around the log and log backups: how to convince yourself

Posted on: May 29, 2009 11:09 am

Misconceptions around database repair

Posted on: May 15, 2009 5:02 pm

A sad tale of mis-steps and corruption (from today)

Posted on: May 12, 2009 8:36 pm

Is running repair on msdb safe?

Posted on: March 25, 2009 9:02 am

Mandatory SQL breathalyzer test

Posted on: March 4, 2009 6:38 pm

Conference Questions Pot-Pourri #10: Shrinking the database before taking a backup

Posted on: November 26, 2008 5:43 am

Corruption survival techniques – useless?

Posted on: November 25, 2008 11:29 am

Sparse columns: misleading info in Books Online

Posted on: October 19, 2008 3:30 pm

Can the hack-the-suspect-database-into-the-server trick work for corrupt file headers?

Posted on: September 2, 2008 10:08 am

Better behavior with suspect databases in SQL Server 2008

Posted on: September 2, 2008 9:44 am

Creating, detaching, re-attaching, and fixing a SUSPECT database

Posted on: August 29, 2008 7:55 pm

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

Posted on: August 27, 2008 5:11 pm

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

Posted on: June 8, 2008 5:12 pm

Backups, trains, birds, and painfully contrived movie plots

Posted on: May 30, 2008 12:34 am

How hard is it to pick the right non-clustered indexes?

Posted on: May 14, 2008 10:13 pm

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

Posted on: January 27, 2008 12:01 am

BACKUP LOG WITH NO_LOG – use, abuse, and undocumented trace flags to stop it

Posted on: October 12, 2007 5:09 pm

Corruption: Last resorts that people try first…

Posted on: September 15, 2007 12:29 am

Common bad advice around disaster recovery

Posted on: September 13, 2007 8:05 pm