Viewing 15 posts - 5,866 through 5,880 (of 6,031 total)
As for global uniqueness, I don't see why the column combination (center_id + cashregister_id + transaction_date) or database id + transaction identity id would not be as reliable, or more...
October 12, 2010 at 3:43 pm
TheSQLGuru (10/12/2010)
<SmartA$$ ON>I LOVE it when clients use GUIDs in their database schemas - more tuning work for me!! 😀 <SmartA$$ OFF>
Oh, come on! That's like a personal trainer saying:
"I...
October 12, 2010 at 11:15 am
The whole idea of encoding your server's network id and date/time stamp inside the primary key is practically a form of denormalization. For example, if you have a point of...
October 12, 2010 at 8:13 am
What a weird coincidence; only a few nights ago, I had a dream that our precious reserve of globally unique identifiers was becomming depleted by poor database architecture design and...
October 12, 2010 at 7:43 am
Four hours of downtime isn't bad for a disaster recovery, and assuming it was completed off peak hours, and the users were notified ahead of time, then it seems like...
October 11, 2010 at 7:35 am
amenjonathan (10/6/2010)
October 6, 2010 at 9:46 am
Steve Jones - SSC Editor (10/6/2010)
Matt Miller (#4) (10/5/2010)
I've asked this before: what's the measurable definition of a "pattern of discrimination"?
...
Again, I don't have an answer. I don't...
October 6, 2010 at 8:31 am
david_wendelken (10/5/2010)
bwillsie-842793 (10/5/2010)
david_wendelken (10/5/2010)
The only true solution is "Equality until it hurts."
And, unfortunately, absolutely no one wants that, as everyone has a different opinion on what "equal" means.
Everyone wants...
October 5, 2010 at 11:48 am
david_wendelken (10/5/2010)
The only true solution is "Equality until it hurts."
If equality means maintaining a quota system, then it will hurt. However, if we hire based solely on a candidate's qualifications...
October 5, 2010 at 11:38 am
mstumpp (10/5/2010)
October 5, 2010 at 8:20 am
I think that men and women bring to the table a set of distinct personality traits, some positive and some negative, at least in terms of their usefulness in IT....
October 5, 2010 at 7:04 am
Also remember that database backups are not just for production servers, it should also go for Development or QA environments as well. Even if the data itself is replaceable, the...
September 30, 2010 at 8:08 am
If you have SQL Server 2008 Enterprise edition, then look at the new Change Data Capture feature. It depends on what purpose the table will serve in the development environment....
September 27, 2010 at 7:57 am
Nevyn (9/21/2010)
Not true, lazy people can totally learn proper SQL.
Just , you know, um, later.
Hey, all the developer needs to do is make sure his SQL basically gets the point...
September 21, 2010 at 3:31 pm
mtillman-921105 (9/21/2010)
September 21, 2010 at 1:59 pm
Viewing 15 posts - 5,866 through 5,880 (of 6,031 total)