This should help

http://www.sqlservercentral.com/scripts/T-SQL+Aids/31774/

sp_spaceused can be very incorrect in SQL 2000

I agree with Johan here. You have to work around this yourself by writing your own header.

It's a way of changing permissions.

If you create sproc A, you might grant execute to use Alice and Bob for this sproc. However, if you're managing security correctly, you might...

That's only part of the question. Did you not read my post? The Raid setup matters, not just the disks. For a SAN, it can also depend on SAN configuration.

A...

Again, the drive letters don't matter. What underlies the drive letters? How many disks under each one and in what format?

I'm not sure what you're asking. Your English isn't really making sense to me.

Maybe this will help.

If I have 2 drives in my server, set up in a Raid 1...

Nice, solution. Tony. I might check that out with a friend, see if we can swap some bandwidth. Especially as my Home Server has died again.

The backup isn't designed to run across a network. The fact that you have some backup waits seems reasonable to me. The network should be slower than local storage.

As far...

What's the D: drive?

Ideally you want to, IMHO, do this:

1. separate data from backups

2. Separate logs from data

3. separate tempdb from data/logs

4. separate heavily used filegroups

separate is separate physical...

I do not believe that you can do this with SSMS without a third party tool. you can use templates to keep snippets of commonly used code, which I've done...

Congrats, Gail, and thanks.

You are loading some CLR assembly, correct? Have you checked that the code in there might not be the problem? What changed before this started happening? A code release?

I think the reflection here is that if you are qualified for a senior level position, you should have some knowledge of what might be asked, or what the job...

I've felt that way a few times over the years when it's 2-0, but I think Texas wins at least one, maybe two this weekend.

I have no horse in the...

Excellent, please show SSMS and T-SQL here.