Viewing 15 posts - 991 through 1,005 (of 3,061 total)
sqlquest2575 (6/18/2011)
I've 4 text files and all of them have date stamp in them and i...
June 18, 2011 at 5:48 pm
valeryk2000 (6/17/2011)
June 17, 2011 at 2:23 pm
Hi Rich --
Looks like you put a lot of work on it - congrats.
Two notes.
1- Only dependent tables are "linked" by referential integrity
As an example, since it doesn't makes sense...
June 17, 2011 at 2:11 pm
craigbroadman (6/10/2011)
The current InvoiceLine table has over 150 columns. We have discussed a few design ideas, one...
June 17, 2011 at 1:24 pm
opc.three (6/17/2011)
I am talking about using SQL Server transaction replication to replicate the resultset of a VIEW from a publisher (the operational database)...
June 17, 2011 at 12:45 pm
1340sreehari (6/17/2011)
I would like to know some table names and fact table names in Banking projects.Will somebody please provide them
No DIM tables? I was going to add DIM_DATE to the...
June 17, 2011 at 12:33 pm
DHeath (6/17/2011)
June 17, 2011 at 12:26 pm
Steve Jones - SSC Editor (6/17/2011)
Master v transaction table isn't clear and I think you are using the terms in a way that I'm not familiar with.
I think this is...
June 17, 2011 at 12:16 pm
Raghavender (6/17/2011)
That link is for whole Instance downgrade....I need only for one database.
Sorry, my fault. I wrongly assumed instance downgrade.
June 17, 2011 at 11:56 am
Still not sure how a view would add any value to an ETL process.
In regards to a proper ETL process, here is how I see it.
--- Database Architecture
1-- Source Database...
June 17, 2011 at 11:52 am
Raghavender (6/17/2011)
Can we attach SQL Server 2008 R2 Enterprise edition Database in SQL Server 2008 R2 Standard edition ?I think we can do it. But need confirmation.
That's a downgrade, you...
June 17, 2011 at 11:33 am
opc.three (6/17/2011)
June 17, 2011 at 10:38 am
DHeath (6/17/2011)
June 17, 2011 at 10:15 am
Anamika (6/17/2011)
Here the beauty is the master tables are giants and trans are tiny
This is very good news, since driving table on those reports is the tiny "transactions" table I...
June 17, 2011 at 9:28 am
opc.three (6/17/2011)
June 17, 2011 at 9:08 am
Viewing 15 posts - 991 through 1,005 (of 3,061 total)