Hmmm that's not what we've been told here by Microsoft. I'll have to wait for our MS guy to get back from vacation, but I'll certainly be asking him...

You should not update stats on everything as that puts an unecessary load on the database server. Instead you should use sp_updatestats which makes a decision on what needs...

How are you running update stats? Are you doing everything each time or are you running sp_updatestats instead?

You can only derive the information from the CPU column. It doesn't provide a percentage.

What you can do to derive the percentage is calculate the entire CPU...

Dbid 2 is tempdb. You should run DBCC CHECKDB on each of the databases and also run hardware diagnostics with special attention on your disks.

See this: http://weblogs.sqlteam.com/tarad/archive/2007/11/08/60394.aspx

You should not be truncating the transaction log. You should either be backing up your transaction log frequently, such as every 15 minutes, or switching...

To add a header to bcp, you'd have to use a view instead: http://www.dbforums.com/microsoft-sql-server/989335-bcp-out-headers.html

The view method is not elegant, and makes the code hard to read as you...

It seems the database server is unable to connect to TORDBDO1. Are you sure that's the proper name? Is there perhaps an instance you should reference? Perhaps...

You have to tell it how to connect to the database server, either Windows authentication or SQL authentication. With Windows authentication, you simply use -T. With SQL authentication,...

EM would be correct, assuming you've got a refreshed view of it.

I'm a little confused though. Is the user that you are testing with the same user...

Somebody removed the permission, either by accident or on purpose.

Yes I have on 2000 or 2005 (can't remember which one as it was a couple of years ago). The user ended up rebooting and then it worked. ...

We use batch requests per second in PerfMon. On our busiest system, we have 1500-3000 batches per second occurring 24/7.

You can use the STATS_DATE function to determine the last time the statistics were updated.

You should also check out sp_updatestats. The benefit of it, starting with 2005, is that...

Rebuilding/reorganizing does not shrink the files, only DBCC SHRINKFILE and DBCC SHRINKDATABASE can do that. But please note that if you shrink your files down, you are actually causing...