Viewing 15 posts - 34,126 through 34,140 (of 59,102 total)
And, no... there's not a lick of dynamic SQL in the code. It's just the changes they made to the forum code does that in the presence of '\'...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 1, 2011 at 8:50 pm
Because D & E have no "PrevID", the look like two top level nodes to me. If I'm wrong, we'll have to try this again. If I'm right,...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 1, 2011 at 8:48 pm
bitbucket-25253 (5/1/2011)
WayneS (5/1/2011)
BTW, I'm aghast --- you've actually used a...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 1, 2011 at 4:50 pm
seanhalvers (5/1/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
May 1, 2011 at 3:29 pm
Craig Farrell (5/1/2011)
I thought I was the only one...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 1, 2011 at 3:19 pm
WayneS (5/1/2011)
BTW, I'm aghast --- you've actually used a SQL...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 1, 2011 at 3:16 pm
CELKO (4/30/2011)
...but this should be pretty fast.
It's not. On a lousy million rows, your code will generate 500,000,000,000 internal rows and take a month of Sundays to run...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 1, 2011 at 12:07 pm
CELKO (5/1/2011)
Instead of trying to make SQLK look like the procedural language you know...
BWAA-HAAA!!!! Listen to you "Mr. PushStack to make a Nested Set". And then you...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 1, 2011 at 12:03 pm
Oh, be real careful, folks. CheckSum_Agg produces duplicates far more than you would ever imagine. Let's do a "little" test. Let's build a million rows of data...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 1, 2011 at 10:52 am
sqlbuddy123 (4/30/2011)
Cursor is the Culprit. The query you captured is a Cursor. Cursors will cause 100% CPU often times. So try to...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 1, 2011 at 9:36 am
That's why I'm glad you decided to take this on, Tom. No BS and personal opinions would be identified as such instead of being identified as gospel. I...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 1, 2011 at 9:14 am
Solomon Rutzky (4/30/2011)
Jeff Moden (4/29/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
May 1, 2011 at 8:58 am
Steve Jones - SSC Editor (4/30/2011)
HA, I like NULLs. I might ask for two articles, one pro and one con.
I like NULLs, as well. I was just thinking of...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 30, 2011 at 8:42 pm
Tom.Thomson (4/30/2011)
Steve Jones - SSC Editor (4/30/2011)
HA, I like NULLs. I might ask for two articles, one pro and one con.
maybe David Portas could write the pro and Jeff could...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 30, 2011 at 8:38 pm
qwerty 87425 (4/29/2011)
And then it usually gives an error message....
...
Any ideas what could be wrong?
Not without seeing the error message you're getting. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
April 29, 2011 at 8:12 pm
Viewing 15 posts - 34,126 through 34,140 (of 59,102 total)