Viewing 15 posts - 1,951 through 1,965 (of 3,061 total)
george sibbald (5/14/2010)
PaulB-TheOneAndOnly (5/14/2010)
george sibbald (5/14/2010)
... and hope there are no flight cancelations:w00t: I'm appalled you don't trust the air travel industry 😀
ours comes to a halt with a...
May 14, 2010 at 6:37 am
srilu_bannu (5/11/2010)
Now my question is :
what is the best way for doing this?
1.SSIS package.
...
May 14, 2010 at 6:27 am
In my opinion MySQL is the poor guy SQL Server while postgreSQL is the poor guy Oracle - don't take me wrong, I've installed both in my personal lab a.k.a....
May 14, 2010 at 6:19 am
Either this is school homework or you got into a consulting project you have no clue how to deliver.
In the first case you should make some effort and we will...
May 14, 2010 at 6:09 am
george sibbald (5/14/2010)
... and hope there are no flight cancelations
:w00t: I'm appalled you don't trust the air travel industry 😀
May 14, 2010 at 6:05 am
An inline view is nothing but a subquery in the WHERE clause.
A derived table is nothing but a subquery in the FROM clause.
May 14, 2010 at 5:53 am
dave_le (5/14/2010)
the 8GB machine is not the OLTP system, it's a server that will be used for loading source data and staging.
I would certainly use a second server to handle...
May 14, 2010 at 5:42 am
dave_le (5/13/2010)
dimensional modeling can be achieved in both of the implementation method i described, the question is which method will perform faster.
Let me simplify it a little and say that...
May 13, 2010 at 3:42 pm
Put two copies of your backups in a removable disk drive, send a guy carrying the disk on his briefcase on the last flight to Nashville, let them restore during...
May 13, 2010 at 3:29 pm
My preference is to go with dimensional modeling.
In a datawarehouse environment design is the key, in a small database no matter how bad was it designed you can always use...
May 13, 2010 at 3:25 pm
mohammed moinudheen (5/13/2010)
May 13, 2010 at 2:48 pm
Aggregate tables are a delivery layer and not a copy of a factual table 😉
May 13, 2010 at 2:32 pm
peter.j.hanlon (5/12/2010)
Is it acceptable to duplicate the same fact table(s) in different data marts?
Yeah, of course it's acceptable.
But there are plenty of reasons why it wouldn't be advised, and I'm...
May 13, 2010 at 1:02 pm
Viewing 15 posts - 1,951 through 1,965 (of 3,061 total)