Viewing 15 posts - 4,156 through 4,170 (of 22,227 total)
Thomas' stuff looks excellent. I'd follow that method. If not, just querying the backupset system database can at least tell you what has been successfully backed up. You can then...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 3, 2017 at 8:31 am
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 3, 2017 at 6:24 am
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),...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 29, 2016 at 9:22 am
Joy. That's going to run great... For certain values of great.
Still, curious about how the UNION resolves vs. the individual queries.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 21, 2016 at 5:38 am
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 21, 2016 at 4:36 am
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 21, 2016 at 4:26 am
sknox (12/20/2016)
paul s-306273 (12/20/2016)
Grant - you have no sense of humour and I have no point for QOTD today.
I don't know -- "Multiple Partitioned Statistics" was a pretty funny (and...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 20, 2016 at 7:41 am
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 20, 2016 at 6:34 am
ChrisM@Work (12/20/2016)
Grant Fritchey (12/20/2016)
ChrisM@Work (12/20/2016)
Grant Fritchey (12/20/2016)
BLOB EATER (12/20/2016)
is that what they label it as "networking evening" on the Tuesday?
No, Friday night. The costume ball.
Have they announced a theme...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 20, 2016 at 6:04 am
ChrisM@Work (12/20/2016)
Grant Fritchey (12/20/2016)
BLOB EATER (12/20/2016)
is that what they label it as "networking evening" on the Tuesday?
No, Friday night. The costume ball.
Have they announced a theme yet for this...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 20, 2016 at 5:30 am
BLOB EATER (12/20/2016)
is that what they label it as "networking evening" on the Tuesday?
No, Friday night. The costume ball.
Have they announced a theme yet for this year?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 20, 2016 at 4:48 am
paul s-306273 (12/20/2016)
No, but I'm sure some people out there would make that argument.
Thanks.
Oh, I've no doubt it's coming.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 20, 2016 at 4:40 am
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 20, 2016 at 4:32 am
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 20, 2016 at 4:28 am
paul s-306273 (12/20/2016)
Grant - you have no sense of humour and I have no point for QOTD today.
Ha!
You're not going to argue that technically what you chose could also be...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 20, 2016 at 4:24 am
Viewing 15 posts - 4,156 through 4,170 (of 22,227 total)