Your suspicion is right. The PIVOT does seem to be the main problematic piece here. Pivots are slow, and CPU intensive when pivoting large amounts of data (in...

All those sp_ procs are symbolic of use of ADO recordsets / datasets in code on the front end. Meaning the sp_CursorFetch will show up in a trace...

Thanks for the reality check, it's actually helpful. At least I now can tell me boss that I am not the only one that thought these requirements were a...

Thanks for the reply. Now I can take your suggestion and... oh wait... there was no suggestion.

I guess I will just figure something out on my own.

We use source control (TFS) as the central repository for our SSIS packages. Deployment techniques will obviously vary depending on your needs and your environment, but having SSIS packages...

- What is the acceptable latency window? -

5 minutes at most

- Does this have to handle Table Def changes also? '

Yes, this is what synchronized means in my...

Set the minimum to whatever you like (0 would even work).

Set the max to 2048

SQL Server is designed to use as much RAM as is available if you leave it on the default memory settings. Using 7 GB out of 10 GB is...

What happens when you try to run this in Management Studio? Do you get an error? What happens?

Obviously change to the database name you want to check...

exec sp_dbcmptlevel 'master'

Make sure the SPNs are created for the service accounts properly.

Whether to go Active/Active or Active/Passive is really a decision that you need to make based upon the available hardware, uptime requirements, performance, load, and licensing. If I were...

What server roles / permissions do you have? Do you have alter trace permissions on the server? You sure it's not a lingering filter in Profiler?

Several of the features of SQL Refactor come in SQL 2008 Mgmt Studio by default. Not all, but many.

they are not continually challenged... or

they are not recognized for their accomplishments...