Jeff Moden (9/16/2010)

---

Paul White NZ (9/16/2010)

---

Perhaps a course on the...

GilaMonster (9/16/2010)

---

Actually no. In last 5 years I've had:

- One database with corrupt log that required a restore

- One very long restart/recovery (12 hours) resulting from poor (non-existent almost) I/O...

WayneS (9/16/2010)

---

You know, I feel for both Gail and the OP here. I think the OP is under a lot of pressure and getting desperate to fix it. And Gail,...

Don't throw the system databases onto the log drive, you're just begging for trouble that way. If you wanted to get really intense about it, each log should have...

Single user case study: Raw Materials got me back into the forums when I spun by off a link from another site that had some instructions on a task I...

The quick and dirty is that readpast skips locked records. This causes a problem if the front page is grabbing a table lock, instead of row/page locks. SQL...

You know how all those websites out there have 'personal questions' and only send resets to pre-set emails in the account and the like? It's because of exactly what...

What happens when you have new files in older folders?

Better approach for the folders would probably be to delete them if they're empty.

Yeah, you ... can... it's not wise. This is a serious caveat emptor.

However, if you end up doing it anyway, get someone to build out a webpage for you...

A pleasure, good luck to you.

Hm, that's true, there are...

Point in time restore via logfiles is about it.

CirquedeSQLeil (9/16/2010)

---

In addition to what Craig has listed, there are the DBA's that must fill all of the roles listed by Craig. Sometimes, there is just no way around...

Note, non-covering, non-clustered index, so we're going here, to the PrimaryKey:

|--Index Scan(OBJECT ([LoadTest].[dbo].[X].[X_IX1]), ORDERED FORWARD)

|--Clustered Index Seek(OBJECT ([LoadTest].[dbo].[X].[PK__X__3214EC273F466844]),

Add HistoryID...

In my experience, the term DBA (Database Administrator) ends up falling into 3 camps, which you have to read the actual job description for to figure out what they want......