It almost looks like the Job History data is causing this. How many rows are there in the Job History? I've found if the Job History gets too big, the clean...

If you use backup and restore then the database level permissions are identical, and the issue can't be at this level. That is unless the user running reports needs permissions...

You could possibly get it more efficient by using a single CTE that numbers the rows, much like your  #unpivot_step2 CTE does, then join to itself, based on reqid and row...

First off, do you have a backup of the reporting database from before the hack? A restore to another server or under a different name would allow you to check...

Any chances this is a SQL Native login, not a domain login? Odds are it's SQL Native and the SIDS don't match between the nodes in the AoHA cluster. Every...

What's the relevance of the nightly full backup with regards to Log Shipping, and why do you want to take a second full backup? Are you only applying logs once...

Personal recommendation based on experience... I would keep the databases on the same instance. Some of the reasons, in no particular order being:

1. If you are doing any cross instance...

Sorry, there is currently no feature in MS SQL Server that exactly correlates with Oracle RAC. Oracle RAC uses a shared memory system that allows them to do all CRUD...

I'm really interested in this:

And let me know if those 3rd party apps are using GUIDs for PKs/Clustering Keys... I know how to fix those so that fragmentation...

Thanks Jeff for your great response, there's a lot of good material in that. Being in the...

Despite all the warnings about talking to your licensing re-seller, and my own caveat that any advice I give must be checked with Microsoft, etc. the following is what I...

Looks like the "Dump on errors" option has been enabled in the Execute Package Dialog box. 

check out the link:Generating Dump Files for Package Execution

Found...

As long as the formatting in the source table is consistent, i.e. always %%S, %%X, %%P, then it comes down to basic substrings. It doesn't matter if any given portion...