I use an @@ROWCOUNT after my use of SELECTs to populate a variable.  IF @@ROWCOUNT=0 then do something.  I think I like that better than prepopulating, but it might be...

I have worked out that a better solution is to leave to DateId as the key field (as per Kimball) but then use the Value field in the table...

All of this is still within BI. In that sense, data science is just another classification of BI with a specific focus on machine learning as opposed to just...

We may differ on what predictive analytics is.  BI can be used to answer such questions as who are my biggest customers or best technicians by evaluation rating.  PA answers...

I agree with Gail on this. ...

You're welcome.  And your comment made me realize I should have added a SUM in my example.  I've updated it accordingly.

HAVING
Q.PERIOD_NUM='2017_01_12'
AND Q.SITE_ID Like 'AP%'
Or Q.

Then you'd be saying that Ralph Kimball's advice is not right.  I'm just quoting him, and over the 15 years...

The parent table is the source (the one end ) of the foreign key.  The child table is at the many end of the relationship.

That doesn't seem quite the same thing.  I assumed you meant that for some business reason some clients can't ever be nullable.  If it is simply a case of a...

I don't understand what you mean here.  First, as...

Whenpresented with a new idea for the way in which databases should be managed,DBAs will be quick to spot weaknesses in the idea and threats that...

Would that alone do it?  Because if so, I have nothing to be concerned about.  There are also other indirect safeguards in my design.  Primarily is...

I wonder if in the age of computers it could be possible to do away with time zones and return to the time when noon at a location was when...