The answer: it depends.

When I was at J.D. Edwards, literally over a thousand Windows servers, 7k+ users, 500+ SQL Servers, etc. We had four domains that were being collapsed into...

Not sure, but are these on separate servers?

Haven't used it, but Sonasoft has an enterprise backup/dr system that you might want to look at.

Personally I used Litespeed to backup to disk, then a tape system to grab...

There are a few reporting services articles here and a few in the July/August and September/October issues of our magazine.

http://www.sqlservercentral.com/store/#sss

I know Mann Publishing has a book as well: http://www.mannpublishing.com/Catalog/BookDetail.aspx?BookID=4

Josh,

I'm not sure why you think views are slow. They should not add appreciable overhead to your query. In fact, anything done in a view can be done with a...

While I don't like temp tables, it might help here. Load some of the data into a temp table and get some calculations done there.

You have to have all the...

I agree with Wayne. Load into a table and work with it. Or execute the script with xp_cmdshell calling isql.

Correct, when you get to a trigger, you are always inside a transaction. It may be the single insert/update/delete statement or it may be inside another transaciton, but one always...

I think you about have it, but I think it's just marked as truncated, or written to disk. The space will get resused eventually.

Boy you have a lot of questions today. A process is equivalent to a thread, but at a higher level in SQL Server. Each process uses one of the many...

The checkpoint, the log writer, QSL agent might be running. Is there some reason you want to know? Books online probably has a list.

No idea. What's the context?

I don't think this will work, but I'm not a deep enough thread programmer to know. Better to store the value in a db, like SQL Server

If file recovery doesn't do it, call MS. They might get you to a stable state. Also, do a full backup of your db file (the .mdf) right now. That's...

I'll clarify that I misworded the question The dependencies was supposed to be the correct one in my reading of BOL and the...