My version will not work with multiple customers.  If you want to use multiple customers, the CTE method mentioned by 

April 4, 2017 at 3:35 pm

#1936658

Or another thought:

SELECT TOP 1 id, cust_id, ISNULL(CompDate, '1900-01-01') AS MaxDate 
FROM Table1
WHERE cust_id = <SOME_GUID>
ORDER BY CompDate DESC

You don't need to do...

I'd do a constraint on the 3 columns for sure since you are saying they need to be unique.  But when you say they need to be unique, do you...

I would venture a guess that statistics were updated so the delete was easier or that the values you were deleting were indexed better the second time.  But there could...

I know I got my MTA in Database Fundamentals and the test was quite easy after working with SQL for a few years.  Spent a lot more time proving my...

Another thing to watch for is SSRS doesn't like changes in server names.  If you are running enterprise edition, it should work fine I think, but if it is standard...

If I am not mistaken, the SSAS Database is just another database.  The stuff it does on the back end is the interesting side.
But if you just need to...

Are others experiencing similar issues?
Is your version of SSMS compatible with your version of Apex?
Is your SSMS version the same as the SQL Server version you are connecting...

I've also seen this issue when I leave SSMS open for weeks at a time or when my system gets low on resources.  You say you have 8GB of RAM...

I think like Grant said, I'd test the restore.  Go with the assumption of worst case scenario:
the VM gets corrupted

Time how long it takes from getting your...

I'd look at what is causing high CPU.  is it SQL or something else?
If it is SQL, I'd start by looking at what is running on the SQL instance....

That looks right to me.
A few things to check though:
1 - remote desktop into the physical/virtual machine hosting the 2012 instance (the machine that you are trying to...

I think it depends on what the processing is actually doing.  SQL does some things really well, others poorly.  C# does some things really well, and some things poorly.

I think knowing what you are trying to accomplish would be a good first step.

That being said, you can make a FK point to any PK.  So there...