Jeff Moden (8/12/2011)

Grant Fritchey (8/11/2011)

Brandie Tarvin (8/11/2011)

I think it's hilarious that you think you're not...

Why would you set up your security that way? Maybe I'm just lazy but 3-5 roles is generally all that's needed and you just move the users in & out...

Lynn Pettis (8/11/2011)

I was going to wait until tomorrow night, but it is close enough.

I am resigning...

A disk queue of 300? YIKES!

Brandie Tarvin (8/11/2011)

I think it's hilarious that you think you're not a real author.

You're writing,...

I wouldn't expect it to behave like that, no. Yeah, I'd expect a slow-down as there absolutely would be contention on the resources, but not something at that magnitude. That...

Well done Brandie. The only real author I know and we still haven't met.

I'd like to recommend you get a copy of this book. And then a copy of this one. They cover what you're asking.

Yeah, set up a role with all appropriate permissions and then add the users to that. Then you don't have to transfer rights from one user to the next. That's...

While I'd prefer you run out & buy 50 or 60 copies of Red Gate SQL Monitor[/url] (my employer), you might be able to get a quick & easy report...

something that's getting worse over time like that, it might be statistics that need to be updated. Try running the UPDATE STATISTICS command on the tables that are accessed by...

Another vote for ERStudio from Embarcadero. Excellent piece of software.

Koen Verbeeck (8/11/2011)

Grant Fritchey (8/11/2011)

No. And that one guy, "tell me how to design a database." Oh...

No. And that one guy, "tell me how to design a database." Oh please. Seriously?

There are scads of books on the topic. You're not going to be able to learn how to do it from a post on a forum.