Viewing 15 posts - 7,681 through 7,695 (of 8,415 total)
Lynn Pettis (6/22/2009)
And we have another one who can't seem to read.
That is genuinely funny.
June 22, 2009 at 3:59 pm
tosscrosby (6/22/2009)
ummm.. i think we need to give him fair amount of chance to prove that he's willing to learn.
Not for me. They were most likely interview or homework...
June 22, 2009 at 3:20 pm
Florian Reischl (6/22/2009)
Payment for solutions on a forum? Sounds like experts-exchange 😛
Who paid for an expert sex change?
Or did I misread that?
😀
Florian Reischl (6/22/2009)
June 22, 2009 at 3:17 pm
GilaMonster (6/22/2009)
Anyone want to take a stab at 800+ lines of cursor-ridden, mostly uncommented code?
Working on it now. :w00t:
Was easier than looking at This One
June 22, 2009 at 3:12 pm
Jeff Moden (6/22/2009)
Surprisingly enough, a Cursor would probably be faster than the Triangular Join method of doing the running totals that Carl currently has deployed.
Not the way I would write...
June 22, 2009 at 3:10 pm
Agreed. However, if the majority of calls are 'typical' then you should use WITH RECOMPILE just on the statement that calls the procedure, rather than forcing a recompile every...
June 22, 2009 at 3:05 pm
Lynn Pettis (6/22/2009)
Unless you are talking about the link to sqlteam (which I didn't follow)
That was it, yes. 🙂
June 22, 2009 at 2:52 pm
Apollo74x (6/22/2009)
Steve Jones - Editor (6/19/2009)
Also, MAXDOP is based on the CPUs/cores, not files.I was aware that MAXDOP was related to #CPU's.
I think Steve was responding to your statement about...
June 22, 2009 at 2:49 pm
Jeff Moden (6/22/2009)
June 22, 2009 at 4:23 am
Jeff Moden (6/22/2009)
...but you should at least warn people when you're going to insert things into the MASTER database.
Absolutely. I ran the posted example earlier - after removing the...
June 22, 2009 at 4:15 am
Another approach would could take advantage of appropriate indexing would be:
SELECT*
FROM@temp
WHERE@searchfield LIKE '%1%'
ANDAssesmentname = @searchtext
UNIONALL
SELECT*
FROM@temp
WHERE@searchfield LIKE '%2%'
ANDNoOfQuestions = @searchtext
UNIONALL
SELECT*
FROM@temp
WHERE@searchfield LIKE '%3%'
ANDThresholdScoreToPass = @searchtext
UNIONALL
SELECT*
FROM@temp
WHERE@searchfield LIKE '%4%'
ANDLastModifiedDate = @searchtext
This may look like...
June 22, 2009 at 3:54 am
Hey Lynn,
I think that is the same technique that 'meg.81' linked to in the opening post.
You are right about the importance of sample data and expected output of course.
Paul
June 22, 2009 at 3:17 am
Did anyone feel the disturbance in the Force when the name Celko was invoked earlier?
Apparently triangular joins are fantastic for running-total or allocation problems!
/sarcasm
June 22, 2009 at 3:11 am
WayneS (6/21/2009)
June 22, 2009 at 3:10 am
Very nice Lutz; I believe we should now call you a 'SQL Master' 😉
Well done.
Paul
June 22, 2009 at 3:01 am
Viewing 15 posts - 7,681 through 7,695 (of 8,415 total)