Grant Fritchey (12/11/2015)

---

Also, this has implications for the database that you're receiving all this from. It really only has a single log backup every day? That basically means that they're...

Yup, as Gail said, the customer wants a read/write database copy. I believe they have some scripts (and possibly data) that they apply (and upload) and are happy to do...

Just guessing here but could this not be due to Kerberos not being configured correctly? If "SomeServer" is on a different domain to the calling server then I suppose "SomeServer"...

Hi Perry,

It was more of a drive-letter swap. The reason was that new, faster storage has been provisioned so data on the old drive was moved to the new. And...

Would like to do a POC using one of the cloud based service providers but it sounds like most of them don't provide out-of-the-box WSFC's. Even Azure. 🙁

No, the cluster nodes are (rather will be) located in the same data centre, same room, same VM hosts. Only difference is that Node-1 and Node-2 are members of a...

Nope, there will be no SAN to SAN replication. The reason why I mentioned separate SAN's was because I wasn't sure if WSFC supported having nodes that accessed non-shared disks....

Hi Perry,

Thank you very much indeed for your reply. And yes, I’m already on level 1 of the stairway (coincidentally while listening to Zeppelin!).

To answer your first question – yes,...

Thanks happycat.

This is more or less the same advice I was given on MSDN. I've managed to get it working the way you've described. At first I had the key...

No replies here. But got a few good suggestions at MSDN: here

Then why not use Google Translate yourself and post your reply in English?

I can't see how this can be an Excel error when Excel is not mentioned anywhere by the OP and also the OP is importing data to SQL Server.

As I...

Oh okay. Well the database option "Auto Update Statistics" is set to "true" so I'm hoping it will update all index based stats. Anyway now I have a possible solution...

Data is imported into these tables via an SSIS package and I have an index rebuild on all the tables as the penultimate step - would this not update the...

Ninja - I tested your theory by temporarily creating two tables to hold the data that the views returned and as you said it solved the problem. The execution plan...