Viewing 15 posts - 106 through 120 (of 1,353 total)
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
If you set up a required project parameter, deploy the project and tie a job to it, there will be an entry in the job properties. I don't know that...
November 15, 2018 at 7:17 am
Viewing 15 posts - 106 through 120 (of 1,353 total)