Tag Archives: administration

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

The Dark Side

Posted on February 25, 2013 by way0utwest

Recently I was invited to speak at the Rocky Mountain Oracle Training Days. It was part of some cross platform talks that have happened in Denver, with some Oracle professionals coming to our last SQL Saturday in Denver. I was … Continue reading →

Posted in Editorial | Tagged , | Comments Off on The Dark Side

Database Maintenance Essentials – Oracle Training Days

Posted on February 11, 2013 by way0utwest

Presented at Oracle Training Days, 2013 Abstract: SQL Server requires a minimal level of maintenance to ensure that the platform functions at an optimum level without any unnecessary outages or problems. This talk will look at the basics of the … Continue reading →

Posted in Presentations | Tagged , , | Comments Off on Database Maintenance Essentials – Oracle Training Days