Viewing 15 posts - 3,781 through 3,795 (of 4,080 total)
I speak fluent Southern and have a working knowledge of English.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 5, 2009 at 8:02 pm
One of our developers tried to write a batch job with a cursor to read the input table once and write parts of it out to three different tables. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 5, 2009 at 4:45 pm
So my question here would be do you assume worst case that it's going to be hit really hard and go for the tabular method and take a hit if...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 5, 2009 at 2:46 pm
Let me go on the record as loving this.
See what you started? Fun isn't it?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 5, 2009 at 1:33 pm
I have an answer IF a given row in the "before" table will never contain information in more than one column. Answer yes or no whether...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 5, 2009 at 12:58 pm
Just a note here that is sort of back on topic. I learned a lesson today that we benefit from being patient with others.
http://www.sqlservercentral.com/Forums/Topic649517-1472-1.aspx
This...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 5, 2009 at 9:32 am
Okay, finally had time to do the inline function and retest. The inline function with CROSS APPLY actually seems to run just a hair faster, averaging 89xx ms...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 5, 2009 at 9:07 am
Thank you for sharing, Gaby. I hate to come across as being dense. I guess I've just been fortunate enough to have the freedom to make...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 5, 2009 at 7:43 am
peter (2/5/2009)
When dealing whith functions that are called frequently, it usually pays off to write them as inline table valued functions (also called parameterized views) and then invoke them using...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 5, 2009 at 7:24 am
More on performance.
I just finished testing a million row update on my laptop. Using a subquery/derived table instead of a function, I was getting around 9.5 seconds...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 4, 2009 at 11:19 pm
No problem. I've posted up a couple of solutions to questions in the T-SQL forums and then been taught the error of my wicked ways. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 4, 2009 at 6:26 pm
POSTS!! Thank heavens, I was afraid I'd gone thread-blind. :w00t:
Either that or a threadinator was going around picking off the contributors, one by one.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 4, 2009 at 6:21 pm
I'd like to echo Jack's comments about putting the article out there. Even though there is debate about the technique used to solve the problem, your article...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 4, 2009 at 5:54 pm
I just have to blink and be the first to ask.
Is this thread dead?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 4, 2009 at 3:46 pm
Andrew Reilly (2/4/2009)
Another flaw with this solution is it doesn't handle adding a negative number of days which is just as important in my eyes
I wouldn't call it a flaw,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 4, 2009 at 2:58 pm
Viewing 15 posts - 3,781 through 3,795 (of 4,080 total)