Viewing 15 posts - 106 through 120 (of 1,354 total)
I agree with what the others have said but I just call it "Bullet-Proofing". ...
February 10, 2019 at 1:56 pm
Atomicity can be very dependent on the purpose of the database. In your address example, normally the dwelling number and street address are safely left together. But I had one...
February 7, 2019 at 8:26 am
In Kimball's 3rd edition book he recommends using views for the fact and dimension tables. I had done this in a couple of instances. As an example, all the inspectors...
January 24, 2019 at 10:19 am
January 22, 2019 at 7:26 am
I prefer the extra hour in the evening rather than when I would rather be sleeping. It is a pain from a technology standpoint, but hardly the worst. I've had...
January 22, 2019 at 7:16 am
Buildingand designing a database isn't that hard
I used to think this. In one sense it's true, it isn't hard to design and build a...
January 17, 2019 at 7:20 am
I would add that there may be issues with extracting the data to another location, like a data warehouse. I have run into these issues, albeit more with an unwarranted...
December 28, 2018 at 9:31 am
We get all that you have stated but you haven't answered the specific...
December 28, 2018 at 7:37 am
Hi Ron,
I'll say it again... I'm right there with you on the multiple...
December 27, 2018 at 12:00 pm
Please don't mistake the following as me taking a swipe at you personally on this. ...
December 27, 2018 at 9:18 am
With integer keys, when you made a mistake with joins you may get a result, but...
December 27, 2018 at 8:04 am
December 13, 2018 at 12:41 pm
My one complaint is "PriceListObj" leaves me hoping that Obj is a placeholder for something more...
November 15, 2018 at 8:30 am
Viewing 15 posts - 106 through 120 (of 1,354 total)