What version of SQL Server?  If 2005, all of this information is available in data management views (dmv's).

However, if it's 2000 you'll need to set up some tracing usinng profiler...

Tough question to answer!  I think we need some more input from yourself.

What is the problem you are having exactly?

If you are having performance issues, you can determine which query/queries...

Interesting reading Junkmail.

We had to go through SOX recently.  Fortunately, I didn't have to read a whole lot of information.  I just got a bunch of files from the auditors...

Personally, I would suggest taking the official SQL Server 2005 Administration course.

Most Microsoft certified training centers will offer the course.

http://www.microsoft.com/learning/syllabi/en-us/2780afinal.mspx

Additionally, Microsoft do have workshops and seminars which are very...

Good luck!

Join the club!  Since my company went through a merger, I have been placed on the Oracle team to learn Oracle and also teach them (supposedly!) SQL Server.

The oracle...

How long is a piece of string??

I tried working this out a while back with no success!  You will also notice that the more fragmented an index is the more...

Yes.

Ideally you have a performance benchmark for your system right now?  If not, I would suggest running it for a couple of hours minimum, but preferably longer to build up an...

On a course at the moment but I do recall something about Opteron and memory a while back when we upgraded our servers.

Can't recall off the top of my head,...

I agree with Kenneth.

Additionally, if you are alerted that the server is failing, depending on the size of the databases, the server could likely fail during the backup.

As Kenneth suggested,...

Possible.

Have you rebuild the indexes?

What is the output of DBCC SQLPERF(LOGSPACE)?

If the database is read only, it may be worth setting the database mode to simple.  This will ensure the log does not grow.

Not seen this one before!  Looking at a few threads on this, it seems pretty nasty though.

Have you ran a DBCC CHECKTABLE/DBCC CHECKDB?

As it's a staging table, have you tried...

Hi,

I use DBCC SHRINKFILE (Logical log name, Size)

I would check DBCC SQLPERF(LOGSPACE) to make sure that the percentage of the log file used.  You cannot shrink the log file any...

I'm not aware of an actual limitation, although I've not used SQL Server 7 for a long time now!

I must admit, I have not worked on an instance with more...

Unless there is space in the log file to shrink to, dbcc shrinkfile will not function as it will not remove the active portion of the log.

Are there any old...