I've put it back in the article text, so you can read it online with colored formatting.

My apologies to Wayne for not getting this done sooner. I thought I...

I agree with you, Jeff, but who do you talk to? I've known plenty of people that were thinking of leaving, and wouldn't want to let their manager know. And...

Maybe someone could send him a blue pawprint?

http://www.youtube.com/watch?v=MJM9eSDjRho

I don't think a 1 minute Tlog interval is too much. I've run that before and it works OK. HOWEVER, it doesn't mean you won't lose data. The important thing...

If you have 500 DTS packages, I bet you have DTS on the headache!

you didn't mention open transactions. Those can prevent the log backups from freeing space.

Also, did the log backups change in size? I used to track this rather than the actual...

Diffs don't impact log backups. At least I didn't think they did. They only reduce the number of log restores needed, but AFAIK (correct me Gail), you could take the...

I tend to agree with Gail. Saving 0.01s on a query run 1000 times an hour can be more important than saving 12 minutes on one run once a day....

I picked way0utwest when I came to Denver, and use that in places. Others I stick with Steve Jones. No real rhyme/reason, but I note that they are part of...

Migrating DTS is not migrating a database. It is something different. And it is a pain.

We are happy to help with questions on items, but not general ones like what...

Oooohh, that's bad.

I didn't think that was bad, a little short, but not bad.

Here are a few books recommended on database design. The diagrams will be listed in there: http://thomaslarock.com/book-reviews/

A few tools I have used:

- Management Studio/Enterprise Manager with Database Diagrams

- ER/Studio (Embarcadero)

-...

a billion dollars is a lot. It's hard to spend it, and MS moves in a lot of areas. Check out Microsoft Research[/url]. The idea isn't that everything gets turned...

This flies in the face of what a backup/restore is for, and in common sense in terms of DR.

I can see the "worried about an investigation" and there are legitimate...