A few weeks ago I found this definition of a date dimension table, created by a smart person named Nicholas Duffy . I'm placing it here so I can find it easily. DROP TABLE IF EXISTS dim_date; CREATE TABLE dim_date ( date_dim_id INT NOT NULL, date_actual DATE NOT NULL, epoch BIGINT NOT NULL, day_suffix VARCHAR(4) NOT NULL, day_name VARCHAR(9) NOT NULL, day_of_week INT NOT NULL, day_of_month INT NOT NULL, day_of_quarter INT NOT NULL, day_of_year INT NOT NULL, week_of_month INT NOT NULL, week_of_year INT NOT NULL, week_of_year_iso CHAR(10) NOT NULL, month_actual INT NOT NULL, month_name VARCHAR(9) NOT NULL, month_name_abbreviated CHAR(3) NOT NULL, quarter_actual INT NOT NULL, quarter_name VARCHAR(9) NOT NULL, year_actual INT NOT
I think the lack of reusability comes in object-oriented languages.... [T]he problem with object-oriented languages is they've got all this implicit environment that they carry around with them. You wanted a banana but what you got was a gorilla holding the banana and the entire jungle. -- Joe Armstrong
Here's how I stopped the flickering pointer in Windows Explorer on my Vista PC with a Radeon HD 4850 video card : Right click on the Computer icon on the desktop, choose Properties > Device Manager > Sound, video and game controllers. Right click on ATI HDMI Audio and choose Disable. Restart the computer, and the flickering is gone.
Comments