Wow, thanks everyone for the overwhelming response in help. I'm going to go with the NOT EXISTS because that feels like the smallest change from the vendor's code, but I...

Nevyn (2/10/2015)

---

What is the cash_pickups table? Seems to be in the plan but not the query? Is one of those tables a view? Or do you maybe have a referential...

TheSQLGuru (2/10/2015)

---

1) That wasn't an "attached" query plan. Help me out here please. 🙂

2) Are the data types all proper?? Conversions can kill!

3) Maybe it would be best to...

All I can do at this time is generate the estimated query plan, which doesn't show any index deletes

I wasn't sure the best way to do that here so here's...

At the start there were about 110k rows in floats, and it chose about 80k to delete.

Counts for the other tables in the query:

transactionlog 2567

transactionlog_tenders 571

transaction_hdr 1690289

transaction_tenders 2354679

I guess my"now" was misleading. I'll look at this again on Monday when I'm back at work. Unless now is the only time you have to look at it.

Thanks

No events logged. Minidumps created (trying to read them now). I think it's an MDX problem. There's something about the way we're building customer groupings in Excel Pivot Tables, I...

Ugh, a year later and I find my own post via Google. Still having this problem. Deleted the cube, redeployed from code, reprocessed, same error. SQL Server 2008 R2...

I would personally follow the path of Import/Export wizard. Did you run everything from Remote Desktop on the server, and that's where you got that message?

You get this error if you try to use the import/export wizard, or are you trying a different solution?

Well, now that's an entirely different problem altogether! Are you just trying to get the data out this one time, will this be recurring with this same configuration, or will...

OK, I read through the thread on that URL I posted earlier. Have you read through that? Exactly which problem are you having? Did you run the Import/Export wizard from...

Just a thought, what version of SQL Server are you using? Not just the year, but the product level?

I'm not sure what the .xml file is that you're talking about, but if you're looking to redeploy this from the source code, then open the solution in BIDS, right...

At this point, with much caution, I would suggest taking a backup, deleting the cube and re-deploying from the source code. I would be much more confident suggesting this if...