Viewing 15 posts - 5,356 through 5,370 (of 22,227 total)
I'm doing something wrong. I can't get either plan to download to my machine.
"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 3, 2015 at 10:43 pm
And, of course, there's always the MSDN Books Online published by Microsoft. The documentation for SQL Server is always helpful to use.
"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 3, 2015 at 2:11 am
Parameters or local variables? There is a difference. Parameters can be sniffed, sampled, so that the known value is used to retrieve statistics from your columns or indexes as part...
"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 2, 2015 at 11:33 pm
xsevensinzx (12/2/2015)
The thing is, not everyone ends with a semicolon.
But they should.
More and more, it's a requirement for new functionality within SQL Server. Ultimately it's going to be a...
"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 2, 2015 at 8:39 am
xsevensinzx (12/2/2015)
"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 2, 2015 at 7:01 am
Glad the book is proving useful. If you are interested in the aspects of the book not covered in the first chapter, database deployment, automation, source control, etc., we have...
"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 2, 2015 at 2:23 am
Not that I know of. FORCE ORDER might do the trick. Forcing HASH or LOOP might also work. Experimentation is probably the only hope. It's just bad code.
"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 1, 2015 at 10:07 pm
GilaMonster (12/1/2015)
polkadot (12/1/2015)
Seriously, does any team really have discussions about these things?
Yes, good teams do, because they know that making time to establish standards and practices saves time later on.
If...
"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 1, 2015 at 7:13 am
GilaMonster (12/1/2015)
Grant Fritchey (12/1/2015)
GilaMonster (11/30/2015)
Welsh Corgi (11/30/2015)
"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 1, 2015 at 2:23 am
GilaMonster (11/30/2015)
Welsh Corgi (11/30/2015)
"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 1, 2015 at 1:37 am
For the slow query the optimizer is not seeing the old ANSI '89 style joins as having a join predicate. Everything goes south from there. I'm not entirely sure why...
"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
November 30, 2015 at 10:46 pm
WhiteLotus (11/30/2015)
"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
November 30, 2015 at 10:33 pm
GilaMonster (11/30/2015)
"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
November 30, 2015 at 12:37 pm
Most of the time, these days, you don't need to sweat disk placement... until you do. If you're experiencing serious IO issues, and you've worked with the SAN team to...
"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
November 29, 2015 at 11:24 pm
Plan forcing can't change the T-SQL syntax. Nothing can, other than rewriting the T-SQL syntax.
Sorry.
"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
November 29, 2015 at 11:21 pm
Viewing 15 posts - 5,356 through 5,370 (of 22,227 total)