Pls don't cross post. Answered in another thread.

I don't believe you can do some of these without being able to read the data. You could grant some roles, like backup or security to someone without having them...

Not sure about heap tables, but if you have a clustered index you can check which datafile these are stored on, which is the same as your table.

Not sure about Oracle,but Netlib and Protegrity have encryption utilities.

Have you checked the SQL error log? Are there any jobs scheduled during the time when it stops working?

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