Viewing 15 posts - 45,226 through 45,240 (of 59,063 total)
The reason why is because the correlated subquery that makes the count gets executed for every row in your temp table. You need to do a little "pre-aggregation" and...
February 7, 2009 at 10:47 am
You're welcome... just remember... if recursive triggers are turned on, you have to take special steps when a trigger updates it's own table or you end up with a really...
February 7, 2009 at 9:17 am
Jonathan Kehayias (2/6/2009)
February 7, 2009 at 8:27 am
Richard M (2/7/2009)
Boy, am I glad to be "someone" now.....
More than that, I've got a pretty healthy respect for you because of the way you just responded and...
February 7, 2009 at 8:06 am
Phil Factor (2/7/2009)
I see CLR more as a way of providing extensions to the SQL Server system to handle complex data. Now that is really exciting.......
For what it's worth, that's...
February 7, 2009 at 7:36 am
idrees.butt (2/6/2009)
What on Earth are you talking about... you said you have an ap with performance problems and that you wanted to write some SQL to fix it. You...
February 6, 2009 at 11:38 pm
Jonathan Kehayias (2/6/2009)
so I did it the right way, rather than the easy way
BWAA-HAA!!! Man, I'm right there with you on that one! Now, all we have to...
February 6, 2009 at 11:15 pm
Jonathan Kehayias (2/6/2009)
Jeff Moden (2/6/2009)
February 6, 2009 at 10:51 pm
Jonathan Kehayias (2/6/2009)
that I wouldn't make in my own code....
February 6, 2009 at 10:36 pm
Jonathan Kehayias (2/6/2009)
February 6, 2009 at 9:54 pm
Don, here is a VERY good example on why CLR's sometimes ARE the way to go:
SQL Server CLR function to improve performance of validating email addresses
Lordy, here we...
February 6, 2009 at 9:19 pm
NGLN (2/5/2009)
Jean-François Bergeron (11/6/2008)
Simply add a where on the key
Maybe a silly question from this beginner, but is the following the right way then?
CREATE TRIGGER trTest_Update ON Test
AFTER...
February 6, 2009 at 5:49 pm
Steve Jones - Editor (2/6/2009)
Brad, thanks for the break and a nice job on the editorial.
We all need to get "reset" at times, to have...
February 6, 2009 at 5:17 pm
I, on the other hand, hope that true relational databases never come to pass. The non-relational ones are a hell of a lot more fun. 😉
February 6, 2009 at 5:11 pm
Grant Fritchey (2/6/2009)
tosscrosby (2/6/2009)
Not the BEST bounty hunter in the galaxy - was it a mutual agreement sort of thing? (now we're really getting wierd)Union.
Heh... ok... now I'm really afraid...
February 6, 2009 at 5:09 pm
Viewing 15 posts - 45,226 through 45,240 (of 59,063 total)