Viewing 15 posts - 18,706 through 18,720 (of 22,219 total)
Regarding Performance: It depends, but yes, CROSS APPLY can be used in place of an INNER JOIN in some situations to realize a performance benefit. It's only going to work...
"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 16, 2009 at 6:15 am
I'm hoping we can get it to 100 pages. Then it should die. Horribly. Suffering.
"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 16, 2009 at 6:05 am
MarkusB (1/16/2009)
The only way to set...
"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 16, 2009 at 6:03 am
No. I don't want to be angry at anyone becuase they're making more than I think they're worth and I don't want anyone angry at me for the same reason....
"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 16, 2009 at 5:54 am
Paresh Prajapati (1/15/2009)
U have to require row level lock with some range of columns..
Really? What happens if you're updating more than one row? What about if you were updating 1/2...
"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 16, 2009 at 5:52 am
GilaMonster (1/15/2009)
There's a school just down the road. I tried it. Didn't enjoy it at all.
There's too much emphasis on the sport side, where to strike to score points 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
January 15, 2009 at 12:52 pm
GilaMonster (1/15/2009)
Grant Fritchey (1/15/2009)
We don't train with a wakizashi at my dojo and I've never tried it.
Neither do we. I have a couple books and I'm seeing if I 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 12:13 pm
GilaMonster (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 11:23 am
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
Viewing 15 posts - 18,706 through 18,720 (of 22,219 total)