Through Microsoft's own testing, SSIS is the worst mechanism for migrating data into Azure SQL Data Warehouse. I would recommend any other method.

DISCLAIMER: I also work for Redgate.

My son purchased his first car ever and it was an ancient & abused Jeep Wrangler. I drove it and it was a blast. When my pickup truck died (ugly),...

Joy. That's going to run great... For certain values of great.

Still, curious about how the UNION resolves vs. the individual queries.

I'd love to see the execution plan for this.

Guessing. If he's doing UNION and not UNION ALL, the UNION acts as an aggregator and it might work to filter differently...

I agree with Jeff (which is pretty standard). It's almost impossible to provide assistance here without details. Sorry.

If you want to continue to poke at it, then I'd suggest capturing...

sknox (12/20/2016)

I don't know -- "Multiple Partitioned Statistics" was a pretty funny (and...

The best way to improve performance for a linked server is to push as much of the query processing as possible on to the remote server. This is best accomplished...

ChrisM@Work (12/20/2016)

Grant Fritchey (12/20/2016)

ChrisM@Work (12/20/2016)

Grant Fritchey (12/20/2016)

No, Friday night. The costume ball.

Have they announced a theme...

ChrisM@Work (12/20/2016)

Grant Fritchey (12/20/2016)

No, Friday night. The costume ball.

Have they announced a theme yet for this...

No, Friday night. The costume ball.

Have they announced a theme yet for this year?

Oh, I've no doubt it's coming.

The party at Telford was the single best Bits party that I've been to (disclosure, I've only been to the SQL Bits events since Nottingham, so any previous amazing party...

Without seeing the actual queries and how you're doing the processing, all I can really offer is vague support. It does sound like you may have some standard code smells...

Ha!

You're not going to argue that technically what you chose could also be...

I never had either. I wrote a blog post on it [/url]after discovering...