Hiya!

Well, that was why I posted that question, to determine whether the OpenRowset() with that usage would evaluate the actual query inside it. I assumed not as if that were...

To answer my own question, for future readers:

Insert via OpenRowset() for 15 million rows = 3.5 hours

Insert via SSIS package for identical query and results = 15 minutes.

Nope, purely a placeholder ... Aimed at any Walking Dead / Honest Trailer fans that might be reading.

Uha!!!! Now that makes perfect sense!

Ignore my last comment, I think it was a Brain-Fart.

Cheers!

Hiya!

[quoteyou can span multiple WSFCs

It's precisely this aspect that is confusing me! What is the benefit of spanning a group of multiple clusters?

And I thought Availability Groups were meant to...

Damn. I did not realise that about Snapshots!

I just had a thought actually! Before I'll get around to testing it I wonder what you guys think:

What if I were to create a snapshot of the database, lets...

Hi Gail

Thanks. Yeah that process you describe is more or less how it currently is done. One of the downsides are that its not particularly fast, the location with storage...

Ohh. Me too!

Hi John,

I am not sure what you mean by join to a calendar table?

John Mitchell-245523 (11/2/2016)

... If there's any chance you won't, you ought to join to a calendar table...

John, that's excellent, most appreciated!

As it turns out I didn't need the AVG() in there, that was left over from my desperate editing to make it work! I just wanted...

This place could be a case study in how NOT to do anything well with a database.

It seems it could also be a case study in corruption and fiddling money...

Yeah sadly no stored procs, otherwise it would have been much easier.

I am on 2014, I shall have a look at XE.

Though when I looked before I couldn't find anything but that was for 2008, things might have changed in my...

Hi Eric,

Thanks for reading. No, the parameters are not embedded in stored procedures sadly. They application uses parameterised queries (prepared statements) so the only thing I can see in...