Viewing 15 posts - 51,271 through 51,285 (of 59,072 total)
JohnG (4/2/2008)
Yes... don't use either... use an INNER JOIN instead
Not always. The matching values resulting from an INNER JOIN can be more than one (1). This will result...
April 3, 2008 at 5:34 am
Antonio,
Your solution doesn't work with the test data I created. Please post your test data generator and the result times you got.
Gus, you're splitting out more than requested and...
April 2, 2008 at 10:31 pm
GSquared (4/2/2008)
Jeff, please tell me what I got wrong on the Numbers table version
At a high level, yes... You split on the "&" instead of the "=" which forces you...
April 2, 2008 at 10:27 pm
Oh, I agree... first step towards some sort of performance is to reduce the number of cursors and UDFs to zero by using the rCTE.
Second step would be to think...
April 2, 2008 at 2:54 pm
All the code blocks in that link show up as little red x's for me...
The thing I'm concerned about is that the word "loops" was mentioned in the test... testing...
April 2, 2008 at 2:49 pm
Heh... nope... different guy :hehe: ... the other one knew a lot more about the system... this one is on a steep learning curve for 2k5 and has seen the...
April 2, 2008 at 2:42 pm
It is amazing that two copies and truncate could be so fast. Guess that's why lot so folks use it... so long as there aren't foreign keys, delete triggers,...
April 2, 2008 at 2:36 pm
Sounds like a winner, J. Thanks for sharing the tips.
April 2, 2008 at 2:32 pm
Steve Jones - Editor (4/2/2008)
Heh... nope... me and my friends used to jump off bridges for fun... Mom didn't mind because we...
April 2, 2008 at 2:31 pm
Steve Jones - Editor (4/2/2008)
April 2, 2008 at 2:25 pm
ALZDBA (4/2/2008)
And I've always been trying to avoid implicit conversions ......... :hehe:
Apparently, even on a million rows... makes no moxnix...
DECLARE @Bitbucket datetime
SET STATISTICS TIME ON
SELECT @Bitbucket = DATEADD(mm,1,EndDate+'01')-1
...
April 2, 2008 at 2:21 pm
ALZDBA (4/2/2008)
And I've always been trying to avoid implicit conversions
Heh... understood. I don't think they make a hoot in the SELECT list... but, I guess I'm gonna have...
April 2, 2008 at 12:16 pm
antonio.collins (4/2/2008)
No fair working at night... my wife won't let me get geeky at night.
Heh... understood... I keep telling mine "How can I miss you if you won't go away?"...
April 2, 2008 at 12:13 pm
Marios Philippopoulos (4/2/2008)
But... assuming they have valid reasons, how can this be done safely and what does it involve?
That much I do know... It's going to be just like any...
April 2, 2008 at 11:41 am
J (4/2/2008)
I have also used the approach of comma-separated single parameter but it has limitations:
- the is a practical limit to the...
April 2, 2008 at 11:34 am
Viewing 15 posts - 51,271 through 51,285 (of 59,072 total)