Viewing 15 posts - 2,311 through 2,325 (of 18,926 total)
read up on inner joins, sum, group by, order by and top
September 25, 2011 at 4:34 pm
Right now the only idea I have in an insert/update trigger.
Depending on how often you error out on that 300 limit would make me decide wether to use an instead...
September 25, 2011 at 8:51 am
That's why sps exist!
September 23, 2011 at 10:14 pm
GilaMonster (9/22/2011)
SQL Server MVP Deep Dives 2 will soon be available for pre-order and early access via Manning publishers: http://www.manning.com/delaney/
Chapter 8: "The how and why of Page Restores", Grant...
September 23, 2011 at 11:24 am
Thanks for the DDL, we still (and mostly) need to see the ACTUAL execution plan.
TIA.
September 23, 2011 at 11:21 am
The left pushes too far, but make no mistake that the people that can, will take every advantage of others that they can.
This is one of the main reason I...
September 23, 2011 at 11:19 am
Stefan Krzywicki (9/23/2011)
Ninja's_RGR'us (9/23/2011)
Then the join with sys.indexes won't work. I've never had the need for it, but I'm sure there's a way around...
September 23, 2011 at 11:09 am
Grant Fritchey (9/23/2011)
Steve Jones - SSC Editor (9/23/2011)
Now I feel like an idiot and a little naive for using Amazon so much: http://t.co/gm3hPsGv
Based on a long history of reading about...
September 23, 2011 at 11:07 am
Yup, the best improvement I've seen is like 24 hours to 10 seconds, maybe even faster.
So I think 1 more round of tuning might prove interesting ;-).
September 23, 2011 at 11:01 am
yes remove the USE 😀
Then the join with sys.indexes won't work. I've never had the need for it, but I'm sure there's a way around it with the...
September 23, 2011 at 10:59 am
montyismobile (9/23/2011)
I would like to thank you for all your help with this cursor issue. When tested against the same data set your query produced identical results...
September 23, 2011 at 10:55 am
SQLRNNR (9/23/2011)
Ninja's_RGR'us (9/23/2011)
SQLRNNR (9/23/2011)
Steve Jones - SSC Editor (9/23/2011)
Now I feel like an idiot and a little naive for using Amazon so much: http://t.co/gm3hPsGv
Good thing NFL players don't work for...
September 23, 2011 at 10:54 am
Ya in compat 80 you can't use a function as a parameter for another function.
Compat mode change the way tsql behaves. The "ironic" twist here is that if you...
September 23, 2011 at 10:52 am
SQLRNNR (9/23/2011)
Steve Jones - SSC Editor (9/23/2011)
Now I feel like an idiot and a little naive for using Amazon so much: http://t.co/gm3hPsGv
Good thing NFL players don't work for Amazon. ...
September 23, 2011 at 10:49 am
Elliott Whitlow (9/23/2011)
Well I admit I'm stumped.. Sorry..CEWII
+1, but I still didn't get the report on the schema diffs between now at 2-3 weeks ago when it began.
SOMETHING changed.
September 23, 2011 at 10:37 am
Viewing 15 posts - 2,311 through 2,325 (of 18,926 total)