Viewing 15 posts - 18,301 through 18,315 (of 22,226 total)
Lynn Pettis (2/19/2009)
GilaMonster (2/19/2009)
Grant Fritchey (2/19/2009)
I'm testing for my 3rd degree on the 14th of March.
3rd Degree black? Woot! Good luck.
My sensei's been pushing me to do 2nd for...
"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
February 19, 2009 at 11:11 am
samalex (2/19/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
February 19, 2009 at 11:06 am
I know of four ways to do this, a function, a tally table, ad hoc queries or changing the data to XML. You have a function. This article [/url]is by...
"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
February 19, 2009 at 10:36 am
GilaMonster (2/19/2009)
What's this? I practice a defensive style. He's the one who knows how to punch
I deny everything.... 😛
I'm testing for my 3rd degree on the 14th of March.
And we're...
"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
February 19, 2009 at 10:29 am
GSquared (2/19/2009)
Also, Seattle may not be Dallas, but bow hunting was a big deal in...
"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
February 19, 2009 at 10:25 am
Steve Jones - Editor (2/19/2009)
Hit you?!?!?! She shoots arrows. Not sure the other side of the room will help.:w00t:
I'm assuming customs will prevent her from getting through with the sword...
"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
February 19, 2009 at 9:33 am
Roy Ernest (2/19/2009)
If I was to be interviewed by you all, I would stand 25 meters away from you all so that I will 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
February 19, 2009 at 9:32 am
Lynn Pettis (2/19/2009)
Grant Fritchey (2/19/2009)
Steve Jones - Editor (2/19/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
February 19, 2009 at 9:31 am
harsha.bhagat1 (2/19/2009)
Even I provide with the table hints 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
February 19, 2009 at 9:28 am
noeld (2/19/2009)
Why so many DBs?You surely have a lot of contention on tempdb!
And everywhere else.
"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
February 19, 2009 at 9:25 am
Steve Jones - Editor (2/19/2009)
Grant,...
"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
February 19, 2009 at 9:23 am
There are a bunch of functions available in the Scripts area of the site. You do a search to track them down. Here's the one at the top of 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
February 19, 2009 at 9:21 am
I still don't understand why you would do this, but you might want to look up the SQL Agent in the Books Online.
"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
February 19, 2009 at 9:19 am
If you look at the execution plan for the DISTINCT, you're getting a huge load because of the DISTINCT operation itself. It's joining ALL the data between the three tables...
"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
February 19, 2009 at 9:17 am
Yeah, Gail's got it. Fix that lookup operation with the included columns and should see a pretty substantial increase in performance.
I think you're getting those scans because of 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
February 19, 2009 at 9:10 am
Viewing 15 posts - 18,301 through 18,315 (of 22,226 total)