Viewing 15 posts - 18,721 through 18,735 (of 22,226 total)
Steve Jones - Editor (1/15/2009)
http://en.wikipedia.org/wiki/Katana
Got to play with sticks last night, Filipino style last...
"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 15, 2009 at 10:53 am
John Dempsey (1/15/2009)
"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 15, 2009 at 10:49 am
Michael Earl (1/15/2009)
DavidB (1/15/2009)
Steve - Should we change the title of this topic to "Are the posters becoming more violent"? 😀
So far, I haven't seen anything violent. Everyone seems...
"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 15, 2009 at 7:51 am
Chris Morris (1/15/2009)
Grant Fritchey (1/15/2009)
"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 15, 2009 at 7:40 am
GilaMonster (1/15/2009)
Grant Fritchey (1/15/2009)
For example, oh Gail, how many swords in your house?
Only one at the moment. I'm considering buying a basket-hilt rapier (local weapons shop has a nice...
"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 15, 2009 at 6:50 am
GSquared (1/15/2009)
Grant Fritchey (1/15/2009)
jcrawf02 (1/15/2009)
Have I mentioned how much I LOVE all of you, and REALLY APPRECIATE all of your help on the forum?(laughs nervously, backs away slowly...)
Oh now, don't...
"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 15, 2009 at 6:46 am
I'm not sure if the resource governor can help at a granular level like this, but it would be worth looking into.
Other than that, no I don't think you can...
"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 15, 2009 at 6:40 am
You know, I don't think it really matters. Each has strengths and each has weaknesses. By and large, I prefer SQL Server and that's where I make my money, 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
January 15, 2009 at 6:36 am
jcrawf02 (1/15/2009)
Have I mentioned how much I LOVE all of you, and REALLY APPRECIATE all of your help on the forum?(laughs nervously, backs away slowly...)
Oh now, don't be getting nervous...
"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 15, 2009 at 6:29 am
We went through a pretty bad experience with virtual servers in development (you can read about my adventures here on SQL Server Central). This week though I was up at...
"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 15, 2009 at 5:46 am
Jeff Moden (1/14/2009)
Chris Morris (1/14/2009)
Jeff Moden (1/13/2009)
Steve Jones - Editor (1/13/2009)
And here I was thinking pork chops were pork chops, not developers' heads.
Oooohhhh.... I might be in trouble... I've got...
"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 15, 2009 at 5:40 am
It sounds like you have some slow performing queries. Can you post the execution plans?
Is there some sort of trigger or something becuase, if I'm reading the queries correctly, one...
"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 14, 2009 at 5:51 pm
Can you post the execution plans?
It does sound like you need a covering index. A key lookup can be very expensive.
"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 14, 2009 at 5:46 pm
Hey Gail,
I see you suggested turning the safeties off to my bestest friend. Holy cow! Triggers calling unsafe CLR code. That ought to be entertaining. Some consultant somewhere is going...
"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 14, 2009 at 1:19 pm
Amol.Naik (1/14/2009)
The Primary Key clustered index is infact defined on the TokenNo VARCHAR(25). Tokens used to be 25-digit codes earlier, but now they are 12 digit. These are guaranteed 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
January 14, 2009 at 1:08 pm
Viewing 15 posts - 18,721 through 18,735 (of 22,226 total)