Viewing 15 posts - 1 through 15 (of 17 total)
Thanks salman.samad for correcting me. I only skimmed the original article briefly.
January 26, 2009 at 8:11 am
good find salman.samad
I had to find myself reading, re-reading and again re-reading the sentences to figure out the point. But I guess we can't complain about Greg Bates' poor...
January 26, 2009 at 7:30 am
TheSQLGuru (12/17/2008)
It is customary and useful to have your int date keys be formatted CCYYMMDD, at least in the classical date dimension scenario. Identities are really not helpful here.
What...
December 17, 2008 at 2:31 pm
Bob Hovious (12/17/2008)
Could you give us a real world example or two using other dimensions besides day?
I have worked with large data warehouse applications that do a lot of data...
December 17, 2008 at 2:30 pm
rkonopka (12/17/2008)
Instead of double converting (first to varchar then back to datetime), wouldn't it be simpler and "cleaner" to do this:select dateadd(dd,datediff(dd,0,getdate()),0)
Enjoyed the article
I've started to use that approach for...
December 17, 2008 at 9:39 am
Jeff Moden (12/17/2008)
Not sure what the text editor you used may have done to you, but there's a lot of missing spaces in your code... for example CREATE TABLE has...
December 17, 2008 at 9:37 am
mike.byrnes (12/17/2008)
If my calculations are correct, then if each year took 5Mb then 200 years would be 1 Gb worth of data, not 100Mb.
I guess I was incorrect that it's...
December 17, 2008 at 9:33 am
Joe Celko (12/17/2008)
December 17, 2008 at 9:29 am
Minority here on SSC where people are a bit more educated about these things, but certainly not in the world at large. I make my living fixing performance messes...
November 25, 2008 at 12:26 pm
sho (11/24/2008)
there seem to be some very ungrateful (and even rude) posts here! and it's completly uncalled for!
I agree. But then again, maybe I'm biased.
November 24, 2008 at 11:47 am
Ed W. (11/24/2008)
November 24, 2008 at 11:46 am
So it would seem that there are two debates going on here. The first is whether or not a numbers table SHOULD exist and the second is what is...
November 24, 2008 at 9:26 am
as Adam Machanic pointed out, you can set the maxrecursion. But one by one recursion won't be very fast.
November 24, 2008 at 8:44 am
As long as you don't need to generate more than 100 numbers, that will work.
Otherwise, you will get:
Msg 530, Level 16, State 1, Line 4
The statement terminated. The maximum recursion...
November 24, 2008 at 8:38 am
I can't really get into what we use it for. But rest assured, I have the need for large numbers tables. I'm not saying it's every day practice,...
November 24, 2008 at 8:28 am
Viewing 15 posts - 1 through 15 (of 17 total)