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...

Correct, but it's not about pointers, it's about physical movement. If the extents are located in order 1, 2, 3, 4, 5 inside the logical file, as they should be...

I'll check and see. We had an issue with the email servers on Sun/Mon, so that might have been it.

apparently everyone is in this thread now, but I'll repeat what's above. Rebuilding indexes will require more space, but you NEVER, NEVER, shrink down to the data size. Even if...

Actually I would think that you would want to rebuild indexes after physical fragmentation as well. I don't have a ref, but anytime you move physically the extents around, you...

I have to say I thought groups would die out, but as I've attended and presented at a few, I think that there is good information, networking, and camaraderie to...

Just so you know, I've had about 6 or 7 interviews since SSC started (none in years) and I called this out in every one. I also used to answer...

The formatting is fixed, or should be. Please let me know if it is still messed up.

I have seen some strangeness with randomness in SQL Server, running the same query...

It's possible, as to how easy? no idea? The original developers of SSC v3 used a lot of nHibernate and generated stuff in places and apparently some things are hard.

I...

LOL, how did I typo that? Keys are on different sides of the keyboard, different hands, I must have been tired.

The majority of my thread notifications were from this thread...

You don't need to take log backups. That advice is misplaced.

I don't think this will occur with a diff, but it's possible if the diff is not related to the...

We have debated about some of the features in Stack Overflow here, especially as they've gained a lot of popularity. I'll post a few threads to get discussion from you,...