I studied at The DW Toolkit (Kimball),a kind of time dimension: 2003 Jan 1 2 ... 31 Feb 1 ... Q1 ... Q4 Week1 Week2 ... You see...
I´ve studied in a Kimball´s book (DW Toolkit) that is important build only on date dimension, in hierarchical form. Date -Year --Month ---Day But...
Whe have a developed a software that´s a good monitoring tools. Only using VBScript + COM+ (packed with vb6). I have a issue monitoring that´s SQL...
I have used the W2K´s file attribute: compress. It saved more than 50% of my disk space! The users say me that the performance is not altered...
[<img src='/community/emoticons/emotion-6.gif' alt=':(' />!] I was losting a lot of time trying to send mail by using SQL Mail, when I used my head!...
Separate names with a comma.