Viewing 15 posts - 17,041 through 17,055 (of 22,210 total)
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.
July 1, 2009 at 6:26 am
Gianluca Sartori (6/30/2009)
GSquared (6/30/2009)
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...
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.
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.
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...
June 30, 2009 at 12:15 pm
Well done Ken!
All those scans converted to nice seeks. Looks good.
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.
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...
June 30, 2009 at 9:45 am
TheSQLGuru (6/30/2009)
2) DTA and the missing index subsystem...
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...
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...
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...
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...
June 30, 2009 at 8:14 am
There really is no way to accurately assess how long a query will take to run. You can have a single row update that should run in about 5ms that...
June 30, 2009 at 8:07 am
Viewing 15 posts - 17,041 through 17,055 (of 22,210 total)