Viewing 15 posts - 4,531 through 4,545 (of 22,219 total)
Josh B (8/17/2016)
"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
August 17, 2016 at 11:32 am
Lots of different standards on this. My one suggestion, regardless of the method you arrive at, be consistent in applying it. Doing some stuff one way, other stuff another, is...
"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
August 17, 2016 at 9:29 am
Yep, and could come from a number of causes. One of the easiest to explain is that you have a Spool operation which is writing out to tempdb. Another is...
"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
August 17, 2016 at 7:34 am
Chris is also offering good advice. It just wasn't there when I started typing.
"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
August 17, 2016 at 7:31 am
Everything Lowell says.
I'm assuming that you're getting a LOOPS join, hence the estimated number of rows is 1? If so, that estimate isn't necessarily off. You need to combine that...
"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
August 17, 2016 at 7:29 am
Brandie Tarvin (8/17/2016)
Steve Jones - SSC Editor (8/16/2016)
Brandie Tarvin (8/16/2016)
If so, what did you think about it? Was it helpful? Was it annoying? Any caveats I...
"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
August 17, 2016 at 6:32 am
JarJar (8/17/2016)
...i've added missing indexes for all the joins possible...
based on an evaluation of the execution plans to understand where indexes are needed... I hope. Not just a blanket,...
"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
August 17, 2016 at 6:02 am
joshua 15769 (8/16/2016)
If i use Primary keys for my query? am i properly indexing my query? sorry for these replies, I really don't know much about data degeneration and such...
Maybe....
"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
August 17, 2016 at 5:50 am
joshua 15769 (8/17/2016)
Interesting! Thank you for the kind response! I'll use varchar(8000) from now on.
Unless you actually need more the 8000 characters.
Jeff is right. VARCHAR(N) is faster than VARCHAR(MAX), but...
"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
August 17, 2016 at 5:45 am
Snargables (8/16/2016)
"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
August 16, 2016 at 3:08 pm
Also worth mentioning is that the rowmodctr value after 2005 is just an estimate. Microsoft says it will be, something along the lines of, "mostly the same values" as it...
"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
August 16, 2016 at 12:20 pm
MyDoggieJessie (8/16/2016)
Gotcha, so it would make more sense to run the stats before the index rebuilds...if use a more concentrated/targeted process before the indexing rebuilds even take place...
Yeah, pretty much....
"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
August 16, 2016 at 12:02 pm
ScottPletcher (8/16/2016)
Grant Fritchey (8/16/2016)
MyDoggieJessie (8/16/2016)
"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
August 16, 2016 at 11:59 am
MyDoggieJessie (8/16/2016)
"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
August 16, 2016 at 10:52 am
crazy_new (8/16/2016)
"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
August 16, 2016 at 10:29 am
Viewing 15 posts - 4,531 through 4,545 (of 22,219 total)