Viewing 15 posts - 8,221 through 8,235 (of 8,416 total)
Jeff Moden (4/21/2009)
April 21, 2009 at 6:43 pm
Morning Flo!
On first look, the performance improvement is down to the QO choosing a much more sensible plan when a VARCHAR is used, rather than a MAX datatype. This...
April 21, 2009 at 3:57 pm
The rumour is that Jeff has been busy porting the .NET common language runtime to T-SQL/native client.
T-SQL.Net - might catch on...?
Just kidding Jeff - I can't wait to see it...
April 21, 2009 at 8:53 am
Phil,
I hear ya - but it's difficult to just take someone's word for it when such differing results have already been posted with detailed scripts, including test data.
I get that...
April 21, 2009 at 7:09 am
Phil Factor (4/21/2009)
April 21, 2009 at 4:55 am
rajamohangade (4/21/2009)
I am planning to use EXISTS for the sake of performance.
You should understand that EXISTS and the JOIN syntax are optimal choices in different situations.
Are you intending to test...
April 21, 2009 at 3:09 am
I agree.
It was just about tolerable the first time, but not twice.
The first time I let it go because it made me remember the word portmanteau
I think I am right...
April 20, 2009 at 11:23 pm
dimp_malhotra (4/20/2009)
ok i am really lost.....am i on the right track or is there something that needs to done on my trigger to avoid concurrency......
Go with Barry's original advice. ...
April 20, 2009 at 11:00 pm
All the information you need to answer question is in this thread, if you look for it.
We've done our bit by providing examples and explaining the techniques.
It's now up to...
April 20, 2009 at 7:45 pm
Jacob,
I guess you could think of it that way. It's probably not 100% technically accurate, but whatever works is all good!
Paul
April 20, 2009 at 7:23 pm
Edward Boyle (4/20/2009)
My strings usually have less that 20 "tokens"
Well that's ok then! Though it is worth bearing in mind that future users of your function may not be...
April 20, 2009 at 6:30 pm
Hey Edward,
The recursive CTE is cool from a technical point of view, but performance is kinda sucky, and any recursion below 100 levels will require an OPTION (MAXRECURSION = x)...
April 20, 2009 at 6:20 pm
Jacob Luebbers (4/20/2009)
April 20, 2009 at 6:15 pm
RBarryYoung (4/20/2009)
Paul White (4/20/2009)
I'm rather a fan of sarcasm.No way.
Monitor sales are up strongly this year, I hear.
April 20, 2009 at 4:32 pm
Viewing 15 posts - 8,221 through 8,235 (of 8,416 total)