FYI.. These instructions were the best for resolving the issue. We all also added the user to the database roles in msdb for SSIS.

Can't really do that on a production system.. 

We had similar situation with our website, we would use one SQL user called "webapp".   This is a problem since we didn't know what user was really doing what.

Our...

You might want to compare your objects in DEV with production.  Sometimes, an index might be missing that could slow performances.   Checking out the hardware (and what's running on them)...

The most common error we get is Error:605, Severity 21, State:1 Attempt to fetch logical page in database 'DataWarehouse' belongs to object '180', not to object 'SAMPLE_FACT'

We run DBCC CHECKDB...

I agree, I think looking at the overall purpose of the query, execution plan and IO statistics will truly tell what method is optimal.  Each method is good depends on...

Have you tried creating an alias through Client Network Utility? 

I would run sp_who2 to check what processes are using up CPU and if any blocking is happening.  

If you have the money, I would recommend using NetIQ's DiagnosticManager.  It...

I've actually resolved this issue with some help from the Microsoft newsgroup. 

Someone from Microsoft suggested I make sure that the ASP.NET account had proper permissions to view all the...

I agree that benchmarking needs to occur. Sometimes there is an occasion where a cursor actually performs better.

We had a case here where the IO and CPU time...

We did run into some issues with Cross Database Ownership chaining. In SP3a there is an option now to enable it at a server or database level. In...

Have you installed the critical patch MS-031? You can't still install the patch unless SP3 or SP3A has been installed.

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/bulletin/MS03-031.asp

I'm creating a plan to do this on QA/development today. I will post my results as soon as possible.

Great thanks everyone for their input.

I'm interested in the one for number created per second. I'm using the SQL profiler and I'm seeing the SQL Server:Access Methods object counter, "workfiles created/sec". I'm curious...