Viewing 15 posts - 121 through 135 (of 692 total)
15 seconds? Time for a new computer!
April 27, 2009 at 12:54 pm
Adam Machanic (4/27/2009)
Hmm, something you've changed is making your version an order of magnitude slower on my test system than either of my versions.
OK, found it. Make...
April 27, 2009 at 12:40 pm
Hmm, something you've changed is making your version an order of magnitude slower on my test system than either of my versions. Here's a simple test I'm running:
--Set up...
April 27, 2009 at 12:38 pm
Florian Reischl (4/27/2009)
Thanks for the new version! I also supposed that a char array should perform better than the string. The current test results show the opposite though...
Did you try...
April 27, 2009 at 10:51 am
OK, I figured out how to do the same iteration on the character array instead of converting to a string (see below). Initial tests on my end are showing...
April 27, 2009 at 10:20 am
Phil Factor (4/27/2009)
Just so we can be sure to test exactly the same code, can you please post the Creation script ?
Actually I used autodeploy 🙂
One of the key things...
April 27, 2009 at 8:28 am
I knew I was going to hear something from you soon.
Next on my list, I promise!
April 27, 2009 at 6:59 am
Hi all,
I have posted a more scalable SQLCLR string split method here:
Thanks to Paul White for pointing me to this thread. Please consider testing all of these methods UNDER...
April 27, 2009 at 6:52 am
Jeff Moden (2/23/2009)Just a very quick glance at your fine code seems to indicate a limit of 80,000 characters for the objects being altered. Although that seems more than...
February 23, 2009 at 6:21 pm
I'm definitely a fan of instrumentation for debugging purposes. Quite a while ago I wrote something called TSQLAssert (http://datamanipulation.net/tsqlmacro/) for that very purpose... It's based on the assertion frameworks...
February 23, 2009 at 2:35 pm
I also seen solutions (and I am still using one, but looking for a way out) that use 'master.sys.All_Columns' as a seed table and generate numbers using the row_number()
When...
November 26, 2008 at 8:12 am
Is it me or do you seem to be in the minority here?
Minority here on SSC where people are a bit more educated about these things, but certainly not in...
November 25, 2008 at 12:17 pm
Anyone can take any example and change it so it performance is important.
You're absolutely right! Why do you suppose that it happens to be so easy?
November 25, 2008 at 8:35 am
If you have a daily report that is run in batch, with no user waiting at the end of a button for the result, it doesn't matter if the SQL...
November 25, 2008 at 7:37 am
And, very happy that Adam has joined in on the conversation... he's the one that first turned me on to "numbers" tables many years ago. Thanks, Adam.
Glad to be...
November 24, 2008 at 7:31 pm
Viewing 15 posts - 121 through 135 (of 692 total)