I studied at The DW Toolkit (Kimball),a kind of time dimension:
IÂ´ve studied in a KimballÂ´s book (DW Toolkit) that is important build only on date dimension, in hierarchical form.
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.