Viewing 15 posts - 3,781 through 3,795 (of 4,081 total)
I was getting 1 million rows in 8.5-9.5 seconds on my laptop without precalculation, but 4 ms for a single row. So faster in batch, but slower in...
February 6, 2009 at 1:09 pm
I speak fluent Southern and have a working knowledge of English.
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. ...
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...
February 5, 2009 at 2:46 pm
Let me go on the record as loving this.
See what you started? Fun isn't it?
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...
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...
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...
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...
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...
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...
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. ...
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.
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...
February 4, 2009 at 5:54 pm
I just have to blink and be the first to ask.
Is this thread dead?
February 4, 2009 at 3:46 pm
Viewing 15 posts - 3,781 through 3,795 (of 4,081 total)