In your admin for the dell RAID controllers, have you checked to see if the batteries are showing warnings? I've seen issues in the past with Dell servers getting slow...

If you don't mind using SSIS - You can also use the transfer jobs, transfer logins, transfer SQL objects, and transfer master stored procedures tasks in SSIS to keep the...

Also look in the actual report server logs (should be located in ..\MSSQLSERVER\Reporting Services\LogFiles) and post if anything is amiss there

Thanks Grant, I am already using a combination of trace and IO, was just wondering if there was something better (i.e. extended events) - thanks for that

Grant, what would be the best way to achieve that? SET STATISTICS TIME ON?

I used to do it using a sp as well, then discovered it was a heck of a lot easier with the trace, then created a process to import a...

If you publication(s) were set up to replicate schema changes then it will replicate. ALTER TABLE, VIEW, PROCEDURE, FUNCTION, TRIGGER will be replicated. ALTER TABLE D-ROP COLUMN is...

You could also create a very "light" server side trace using the default TSQL template in Profiler, remove all the columns you don't need, and a filter for the exact...

Rather than adding the column to the '"leading edge" you might want to consider adding it to the end of the index...this may help with the overall selectivity of the...

You should do it for all disks from the initial set up, and most importantly (not sure this still applies for server versions beyond 2008 so you may want to...

If you are simply physically moving the database files from SAN - SAN, it's just a matter or changing the locations via TSQL, shutting down the replication agents as you've...

I manage 21 servers with about 12 DB's per server, total size is about 11TB (with 2 servers accounting for 9TB of that total amount)

Good Lord Jason :w00t: HOW...

I believe this is an issue with your account versus the "proxy" account. This is a very common issue....

Verify that the proxy account can access the FTP site using...

This may work better as you don't need to run it for any given table SELECT OBJECT_NAME(c.object_id) ,

c.name ,

...

Please refer to this excellent article regarding Transaction Logs: http://www.sqlservercentral.com/articles/Administration/64582/

Bulk-logged is very similar to full recovery, except that in bulk-logged, bulk operations are minimally logged. When operations are minimally...