Viewing 15 posts - 4,156 through 4,170 (of 22,224 total)
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
Stewart "Arturius" Campbell (12/19/2016)
Have never had the need to use this, so learned something new today, thanks Grant.
I never had either. I wrote a blog post on it [/url]after discovering...
"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:23 am
There are a bunch of common problems you have to avoid in SQL Server to aid in performance. Generally, check these first. They include, but aren't limited to:
functions on columns...
"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 19, 2016 at 8:02 am
I agree with what everyone else is recommending.
I would like to note that if you're asking if you have to restore to 2008 or 2012 or something, the answer...
"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 19, 2016 at 7:35 am
Viewing 15 posts - 4,156 through 4,170 (of 22,224 total)