Viewing 15 posts - 4,801 through 4,815 (of 5,843 total)
Joe Celko (1/19/2009)
January 19, 2009 at 9:01 am
Again... I just don't understand what you're trying to tell me and why I should "drop the set based mantra for 30 seconds". The cursor is slower than...
January 17, 2009 at 8:13 pm
1) http://sqlblog.com/blogs/hugo_kornelis/archive/2007/11/28/poor-men-see-sharp-ndash-more-cursor-optimization.aspx. Don't forget to examine the original post mentioned at the top.
2) to Joe: there are several implementations for regex that developers (both XP-based and CLR-based) can...
January 17, 2009 at 3:38 pm
Yep... already admitted that. CLR's are better at most RegEx and file handling. With those two exceptions (so far), and with only rare exception, people can usually at...
January 17, 2009 at 1:19 pm
Besides... I need to see the crap code someone raced a CLR against... people that can't think of set based solutions are usually pretty crappy cursor writers, as well.
Sorry, posted...
January 17, 2009 at 10:15 am
Jeff Moden (1/17/2009)
TheSQLGuru (1/17/2009)
1) there is less tempdb storage overhead to a cursor (some of them anyway) than putting the entire set of data in tempdb.
Heh, ok, you said it,...
January 17, 2009 at 9:49 am
Jeff Moden (1/16/2009)
TheSQLGuru (1/16/2009)
I sure do wish someone with CLR knowhow (and some free time) would take the opportunity to do some CLR...
January 17, 2009 at 8:19 am
Tempdb constraints come to mind here. 🙂
I sure do wish someone with CLR knowhow (and some free time) would take the opportunity to do some CLR code you could...
January 16, 2009 at 4:50 pm
Jeff, it strikes me that pretty much all of your examples here and in other threads have a clustered index on the key of concern. What happens when it...
January 16, 2009 at 3:16 pm
Jeff:
1) For your follow-on articles, when you demonstrate the 'tsql trick' solution, please make sure you caveat the hell out of it about how and why you can get incorrect...
January 16, 2009 at 7:37 am
One other thing to check: SSMS has a specific set of SET statements that it executes on connection and whatever API Peoplesoft uses to connect has another. Check...
January 9, 2009 at 5:22 am
Marios Philippopoulos (1/8/2009)
TheSQLGuru (1/8/2009)
January 8, 2009 at 10:29 am
Mark, do this - FORCE sql server to use the two indexes you think it should use (from mytable WITH (INDEX=myNCindex)...). Now show the estimated query plan for that...
January 8, 2009 at 9:11 am
It is my belief that even if you rewrite the trigger to only do the audit update on rows where something is different between inserted and deleted the trigger will...
January 8, 2009 at 9:07 am
I think there are PLENTY of common (and uncommon) ways for SQL Server based apps to perform suboptimally. 🙂 Plus, just because some schmo like me says something...
January 8, 2009 at 7:42 am
Viewing 15 posts - 4,801 through 4,815 (of 5,843 total)