Viewing 15 posts - 121 through 135 (of 692 total)
15 seconds? Time for a new computer!
--
Adam Machanic
whoisactive
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...
--
Adam Machanic
whoisactive
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...
--
Adam Machanic
whoisactive
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...
--
Adam Machanic
whoisactive
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...
--
Adam Machanic
whoisactive
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...
--
Adam Machanic
whoisactive
April 27, 2009 at 8:28 am
I knew I was going to hear something from you soon.
Next on my list, I promise!
--
Adam Machanic
whoisactive
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...
--
Adam Machanic
whoisactive
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...
--
Adam Machanic
whoisactive
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...
--
Adam Machanic
whoisactive
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...
--
Adam Machanic
whoisactive
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...
--
Adam Machanic
whoisactive
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?
--
Adam Machanic
whoisactive
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...
--
Adam Machanic
whoisactive
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...
--
Adam Machanic
whoisactive
November 24, 2008 at 7:31 pm
Viewing 15 posts - 121 through 135 (of 692 total)