As the question says that you live in Colorado, "Mountain Standard Time" is the best possible answer.  It's right all the time, as opposed to "US Mountain Standard Time", which...

This actually isn't quite right unless you are living in Arizona.  But I think you live in Colorado.  In that case, the proper time zone is "Mountain Standard Time".  What...

• This reply was modified 5 years, 1 month ago by  RonKyle.

Agreed.  Thanks for clarifying.  My use of the terminology was imprecise.  I'll correct the answer later.

Just to elaborate, if you set up the other packages to run within a master package, you can then pass the variables that way.  If you're using SQL Server 2012...

I would suggest that you bring all the records added or modified since the last run and then load the changes/additions from there.  I would also suggest you avoid a...

There's not a lot of information here.  But my first thought is to set up a cross reference fact table at the granularity of customer location and store location with...

There are no sour grapes at all.  You all really need to learn that you should attack ideas and not people.  However, in the interest of clarification: Gail, you hypothesized “You...

she then concludes that these results should all but put the nail in the coffin on integers vs naturals keys.  This is NOT a valid...

she then concludes that these results should all but put the nail in the coffin on integers vs naturals keys.  This is NOT a valid conclusion to...

They use previously "frozen" balances and then calculate what the current transactions are and do the math on the previous balance.

Agreed.  Most balances with which I've worked have opening and...

've had the same bank account for more than 20 years.  I'd hate to have to wait for them to compute a balance every time.

A balance is one of those...

Are you striping your backups?  I had a greater than 1TB database and changed it to striped backups.  It knocked both the backup and restore time in half.  That might...

I used this link and found the article with no issues: https://sqlinthewild.co.za/index.php/2011/02/15/are-int-joins-faster-than-string-joins-2/

The really hard part is getting people to agree that there is not always a natural key to be had and that those natural keys that seem adequate are frequently...

• This reply was modified 5 years, 4 months ago by  RonKyle.

The article certainly isn't about CHAR v.s. VARCHAR v.s. INT PKs. She wisely picked an example that's not only common and, sometimes, hotly contested, but one that's incredibly simple and...