Viewing 15 posts - 11,986 through 12,000 (of 22,224 total)
GilaMonster (8/23/2011)
Ninja's_RGR'us (8/23/2011)
Grant Fritchey (8/23/2011)
Ninja's_RGR'us (8/23/2011)
Awesome info.You guys should really get together and write books or talk @ PASS sometimes :hehe:.
Now what could you possibly talk about? :Whistling:
That's a great...
"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 23, 2011 at 10:16 am
Roy Ernest (8/23/2011)
"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 23, 2011 at 10:15 am
Ninja's_RGR'us (8/23/2011)
Awesome info.You guys should really get together and write books or talk @ PASS sometimes :hehe:.
Now what could you possibly talk about? :Whistling:
That's a great idea! Maybe next 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
August 23, 2011 at 7:53 am
I'm not sure I understand the question.
Are you saying that you want to transmit a record, or records, to the other server, but only when a certain action is taken...
"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 23, 2011 at 6:33 am
Parallel execution probably. Hard to know what to do without seeing the code though.
"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 23, 2011 at 5:56 am
GilaMonster (8/23/2011)
Ninja's_RGR'us (8/23/2011)
Ok but what makes you take that call? How can you tell that it's not the index that's @ fault to generate the bad plan?
Stats tell the...
"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 23, 2011 at 5:43 am
Excellent code. Nice article. Well explained.
But I have to say, articles like this really do make me nervous. It seems like a very healthy percentage of our fellow database professionals...
"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 23, 2011 at 5:38 am
Ninja's_RGR'us (8/22/2011)
nawillia (8/22/2011)
"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 22, 2011 at 6:23 pm
Thanks. I just try to help out.
Hey, I like technical books too. Everyone at my old job thought I was weird when I picked up Kalen Delaney's SQL Server 2008...
"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 22, 2011 at 4:05 pm
Christi Wilson (8/22/2011)
"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 22, 2011 at 3:33 pm
I'd say that it's the XML that's killing you. Passing XML into a query is fine, but you should load it into temp tables as soon as possible. Constantly querying...
"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 22, 2011 at 3:25 pm
I don't know that I'd say that's always right, but yeah, that can be a great solution. Add the columns the the INCLUDE list of the index that was 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
August 22, 2011 at 12:10 pm
EjSQLme (8/22/2011)
"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 22, 2011 at 12:06 pm
Christi Wilson (8/22/2011)
"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 22, 2011 at 12:03 pm
EjSQLme (8/22/2011)
Grant Fritchey (8/18/2011)
EjSQLme (8/18/2011)
Grant Fritchey (8/17/2011)
"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 22, 2011 at 11:41 am
Viewing 15 posts - 11,986 through 12,000 (of 22,224 total)