Viewing 15 posts - 181 through 195 (of 378 total)
Hey Jeff,
Well I "worked" till 7 am in the morning doing all sorts of stuff with the code., then took a 2.5 hour sleep and wend to do something else...
May 7, 2011 at 2:49 pm
WayneS (5/6/2011)
May 6, 2011 at 4:06 pm
UMG Developer (5/6/2011)
Nadrek (5/6/2011)
Peter: On my machine, you've definitely beat the article's original try, and beat my Union version, but the 0 based permanent temp table is still better.
Interesting... I...
May 6, 2011 at 2:52 pm
Nadrek (5/6/2011)
Wayne: thank you for...
May 6, 2011 at 2:46 pm
WayneS (5/6/2011)
Nadrek (5/6/2011)
peter-757102 (5/6/2011)
May 6, 2011 at 1:43 pm
I did modify the test set and tested the code of course, I just want to see comparable graphs from identical servers as the others originated from. Maybe it is...
May 6, 2011 at 12:15 pm
New graphs would be nice, I got the feeling that the on-the-fly generated tally is now just as fast, if not faster then a 0 based physical tally table. The...
May 6, 2011 at 10:50 am
Hi Jeff,
After looking at it some more, I discovered an obvious tweak, I think you will like this A LOT.
create FUNCTION dbo.DelimitedSplit8K_T0
--===== Define I/O parameters
...
May 6, 2011 at 7:37 am
Nadrek (5/3/2011)
Jeff Moden (5/2/2011)
Well, that makes 3 of us. We have a quorum! 😛 Phil Factor wrote an article fairly recently on all the XML, JSON, and...
May 6, 2011 at 7:13 am
Hi Jeff,
I finaly got a quick look at this work of you and other subsequent posts and it looks like great work.
I did notice someting that striked me as odd...
May 6, 2011 at 4:28 am
coldsteel2112 (4/6/2011)
peter-757102 (1/10/2011)
April 7, 2011 at 5:56 am
Jeff, I can't wait for your new articles.
The CTE and sorting aproach I had to deal with a few times and isn't that new to me, but nested sets and...
March 14, 2011 at 4:48 am
Richard Warr (2/21/2011)
February 21, 2011 at 4:38 am
Kartik M (2/21/2011)
hi peter,The function DATENAME( datepart, date ) alone is enough to return the required data [MonthName], Is it necessary to use the combination of DateADD function too??
Indeed, I...
February 21, 2011 at 4:30 am
I got two short comments as I am not going to make this a long explaining story.
1. Take a look at the build in function called dateName in combination with...
February 21, 2011 at 2:40 am
Viewing 15 posts - 181 through 195 (of 378 total)