Tag Archives: administration

Resetting DMVs

Posted on March 13, 2013 by way0utwest

Recently I was working on an indexing presentation and looking for missing, duplicate, and unused indexes. As I set up demos to show the effects of indexing, I was constantly adding and deleting objects, and even resetting the DMVs to … Continue reading →

Posted in Editorial | Tagged | Comments Off on Resetting DMVs

T-SQL Tuesday #40– File and Filegroups

Posted on March 12, 2013 by way0utwest

It’s the second Tuesday of the month and time for T-SQL Tuesday again. This is a monthly blog party, where the participants write on a particular theme. This month Jen McCown, of Midnight DBA fame, invites us to talk about … Continue reading →

Posted in Blog | Tagged , , , | 4 Comments

Dropping Indexes

Posted on March 6, 2013 by way0utwest

While working on some demos recently, I needed to drop an index for a test. I executed this generic statement for an index I’d just created. 1: DROP INDEX ix_IndexName Needless to say I was surprised when I got this … Continue reading →

Posted in Blog | Tagged , , , | 3 Comments

Attaching an MDF with no Log (AdventureWorks)

Posted on February 27, 2013 by way0utwest

Attaching an MDF file without an LDF file can be a little tricky. I had to go through this recently when I downloaded the AdventureWorks2008R2 database, which was just an MDF file. I know I’ve done this before, but I … Continue reading →

Posted in Blog | Tagged , , | 1 Comment