Viewing 15 posts - 17,056 through 17,070 (of 22,226 total)
GSquared (7/1/2009)
Grant Fritchey (6/30/2009)
GSquared (6/30/2009)
GilaMonster (6/30/2009)
GSquared (6/30/2009)
john.arnott (6/30/2009)
3NF-Boy got me ROFL with this response:w00t:. I can't wait to see Gus's answer. 😉
No more waiting...
"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
July 1, 2009 at 7:11 am
That's a pivot operation. Do a search on it. I'm not great at them, so you'd be better off looking up what the real experts have to say.
"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
July 1, 2009 at 6:26 am
Gianluca Sartori (6/30/2009)
GSquared (6/30/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
June 30, 2009 at 4:24 pm
GSquared (6/30/2009)
GilaMonster (6/30/2009)
GSquared (6/30/2009)
john.arnott (6/30/2009)
3NF-Boy got me ROFL with this response:w00t:. I can't wait to see Gus's answer. 😉
No more waiting required. Let...
"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
June 30, 2009 at 4:18 pm
I ain't singing and I ain't dancing, but I will take one of those particle accelator things please.
"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
June 30, 2009 at 12:47 pm
Roy Ernest (6/30/2009)
At least I am not dead yet.... I am not a ghost....:hehe:
Heh. You really were skipped right by. Shame since you had the answer PDQ.
"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
June 30, 2009 at 12:29 pm
That looks like you're on the right track to me.
By the way, it's kind of a waste of space & time & readability to put 'tbl_' in front of table...
"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
June 30, 2009 at 12:15 pm
Well done Ken!
All those scans converted to nice seeks. Looks good.
"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
June 30, 2009 at 12:13 pm
I was never aware of a particular sweet spot in terms of compiles to batches. The fewer the better was the only rule I operated under.
"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
June 30, 2009 at 11:57 am
jcrawf02 (6/30/2009)
Paul White (6/30/2009)
WayneS (6/29/2009)
Hey gang... I'm looking to take "She who must be obeyed" (in this case, both my wife and mother... )
When I first read that, it sounded...
"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
June 30, 2009 at 9:45 am
TheSQLGuru (6/30/2009)
2) DTA and the missing index subsystem...
"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
June 30, 2009 at 9:44 am
I agree. I wouldn't add that data to your Names table. You should go for a more normalized approach with a Subjects table and, like the last post said, 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
June 30, 2009 at 9:39 am
5 recompiles for 1000 batches is pretty good. 50% compile rate on your batches suggests that you've got lots of ad hoc queries. If it's a reporting system, that ratio...
"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
June 30, 2009 at 9:37 am
For only 5, I'd say roll your own. You get most of what you need from Perfmon & server-side traces. Spending money on a tool for so few servers 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
June 30, 2009 at 9:34 am
mjarsaniya (6/30/2009)
you are beginner or expert , first do best try to get answer from BOL 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
June 30, 2009 at 8:14 am
Viewing 15 posts - 17,056 through 17,070 (of 22,226 total)