Viewing 15 posts - 3,586 through 3,600 (of 4,081 total)
The answer to these kinds of questions is usually "It depends." Two significant variables here are the size of the name column (average of four words)...
March 5, 2009 at 9:18 am
Could we see the fully generated string please? Preferably, one generated with a print statement right before statement 99 where the error occurs.
However, I'm pretty sure Florian's right....
March 5, 2009 at 8:58 am
Corrected version. Still runs in a millisecond or less.
;WITH
L0 AS (SELECT 1 AS C UNION ALL SELECT 1),--2 rows
L1 AS (SELECT 1 AS C FROM L0 AS A,...
March 5, 2009 at 8:15 am
My bad.
I skimmed over the part that said nothing could be created in the DB. I was trying to poke fun at Jeff because he...
March 5, 2009 at 8:11 am
Thanks for the reply. It's always good to know what the resolution was. I sent you that last example because I believe it will work...
March 5, 2009 at 7:51 am
JEFF !!!! You don't have a tally table available?
select dateadd(yy,datediff(yy,0,getdate())-5,0)+ N-1
from dbo.tally
where N < datediff(dd,dateadd(yy,datediff(yy,0,getdate())-5,0),getdate())+2
Runs almost a full millisecond faster at 5-10 years. 😉
Pretty much a...
March 5, 2009 at 7:46 am
(1) We can't see your list of tags... please post them as an attachment.
(2) I'm not sure why you feel the need to store the tags. ...
March 5, 2009 at 7:29 am
Deleting your posts strikes me as the equivalent of the people who disconnect from losing positions in online chess games. It's the equivalent of kicking over the...
March 5, 2009 at 7:11 am
Great minds think alike. I'm just happy that I'm not the only person on earth who might remember that song. 😀
March 4, 2009 at 2:53 pm
ARTIST: Tom Lehrer
TITLE: Lobachevsky
Lyrics
Who made me the genius I am today
The mathematician that others all quote
Who's the professor that made me that way
The greatest that ever got chalk on his...
March 4, 2009 at 2:21 pm
try to order the list of values so that the most frequently found values are placed first
Grant, I've read somewhere a while back that this is actually...
March 4, 2009 at 11:16 am
I'm glad you said that, Gail. I did a single test on that a while back because I figured the internal logic had to be the same, but...
March 4, 2009 at 10:53 am
Having spent my lunch hour perusing his blogsite, it's very tempting to do a parody of it, but we've already spent more time unloading on him than he's worth. ...
March 4, 2009 at 10:47 am
Some other priceless pearls from the "Mangled" SQL Blog....
5. Avoid using SELECT * FROM when only a few columns are needed. Try to specify each column.
How about avoiding using SELECT...
March 4, 2009 at 10:31 am
Viewing 15 posts - 3,586 through 3,600 (of 4,081 total)