Viewing 15 posts - 16 through 30 (of 1,311 total)
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...
September 11, 2019 at 2:27 pm
'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...
'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...
September 11, 2019 at 12:50 pm
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...
September 11, 2019 at 11:52 am
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/
September 9, 2019 at 8:34 pm
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...
September 9, 2019 at 5:18 pm
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...
September 9, 2019 at 3:15 pm
I'm not entirely clear on what you are hiding and why. I have hidden accounts under similar circumstances using the permissions boxes to hide certain members. There is subsequently a...
September 9, 2019 at 12:46 pm
These are some of the same principles I learned doing staff work in the Army.
September 2, 2019 at 1:54 pm
I dislike them as PKs and I believe using a surrogate is a better choice. Why? If I do change something, I'm not changing it in many places, which is...
August 21, 2019 at 7:59 pm
You go ahead and do your de duplication that will inevitably occur with some surrogate only keys. I've seen these results many times. I have yet to see a state...
August 21, 2019 at 1:26 pm
This is one reason I dislike many natural keys as PKs.
I don't understand how this follows from the discussion.. First, there's not a whole lot of cases where there is...
August 21, 2019 at 12:48 pm
OH is actually an alfa surrogate for Ohio. And SSN is a semi-arbitrary surrogate key that originally carried some geographic information but not so much any more.
This is not according...
August 19, 2019 at 6:40 pm
Ok, let me clarify "keys vs data" since I seem to have annoyed the purists.
I am not a purist, but a practicalist. That may not be a real word, but...
August 15, 2019 at 8:25 pm
A few comments:
August 15, 2019 at 6:24 pm
Agree that the primary key cannot be subject to change. Any change must be due to some extraordinary circumstances and not a matter of routine or reasonable possibility. There are...
August 12, 2019 at 6:37 pm