Viewing 15 posts - 8,746 through 8,760 (of 9,715 total)
Why bother copying the files for TempDB? It practically gets "recreated" every time the service gets stopped. Just run the Alter Database command on the files, stop the...
July 23, 2008 at 6:24 am
And yet a poorly written ETL process could inadvertantly orphan records. Since I might not be the only person writing ETL processes (we're starting out with two DB sources,...
July 21, 2008 at 10:56 am
You mean besides referential integrity between the Fact table and the Dimension tables?
My setup includes 3 star schemas that overlap each other on one of the dimensions. I'd like to...
July 21, 2008 at 7:27 am
Steve, Unfortunately, all my different entities have different fields. Again with the Junk Dimensions issue. I might end up with a 40+ column wide "archive" table with millions of...
July 18, 2008 at 7:26 am
Isn't Ralph the name of your evil twin brother, Ryan? @=)
July 18, 2008 at 5:40 am
I've actually been thinking about that, but it would involve adding at least 12 more tables to my DB.
I did find an interesting article on "Junk Dimensions" in SQL Server...
July 17, 2008 at 12:54 pm
I used to think that, but given how Indexes are set up (depending on the Clustered or Non-Clustered) and whether or not you have Triggers / Defaults / Etc... I...
July 17, 2008 at 5:05 am
Ryan,
If you read his first post, he doesn't want to SUM the QuantityShipped. And I was only addressing the math problem, not the GROUP BY (although I should have...
July 17, 2008 at 5:01 am
Your aggregate is in the wrong place.
Your code = (SUM([Unit Price] * QuantityShipped) / QuantityShipped) AS [A.S.P]
SUM should be on the outside of the parens, not inside the...
July 17, 2008 at 4:33 am
Tomm,
You are correct. This is exactly what my BUs and Boss want to accomplish with this. Historical auditing as well as reporting.
I'd love to see this paper of...
July 16, 2008 at 6:45 am
Hmm. That's a point I hadn't taken into consideration. I'm pretty new to all this DW / Cube stuff and am following the requirements laid out by the...
July 15, 2008 at 4:06 am
Actually re-assessing is what I'm in the middle of.
Problem is Datawarehouse design where I have to account for changing Entity records (different types of people where each "type" is in...
July 14, 2008 at 11:30 am
But if I misunderstood your question and you're just trying to run it on all DBs in Dev (for instance) and then later move it to test...
You have a couple...
July 14, 2008 at 11:14 am
First of all, you shouldn't be creating the stored procedure in all three environments at the same time. It violates the SDLC (Software Development Life Cycle) process and could...
July 14, 2008 at 11:07 am
Michael,
Your last post actually made sense. Until of course, I created another data flow task.
Of course, I can't be sure until I've finished running this step, but it appears...
July 10, 2008 at 11:23 am
Viewing 15 posts - 8,746 through 8,760 (of 9,715 total)