Viewing 15 posts - 1 through 15 (of 74 total)
Yep. With you there on the challenges. I also agree that everyone generally wants to do the right thing and it is frustrating when it's difficult to determine what the...
December 14, 2020 at 6:02 pm
I've been hitting this very problem lately. There are two problems really. The first is in the vague understanding of what it means for data to "leave a given region"....
December 13, 2020 at 7:41 pm
L' Eomot Inversé (12/15/2011)
Thomas-282729 (12/15/2011)
December 15, 2011 at 11:49 pm
L' Eomot Inversé (12/14/2011)
Thomas-282729 (12/13/2011)
I do not consider check constraints to be "business logic" even if it is a rule dictated by the business.
Amazing. Rules dictated by the...
December 15, 2011 at 10:27 am
Let's step back for a second. The point I have made multiple times is that if you have to resort to T-SQL cursors, that is logic that almost assuredly does...
December 13, 2011 at 10:56 pm
My experience has been that CS majors learn more about how compilers, sorting algorithms and computers work than how make effective use of them. The CS majors with whom I've...
December 11, 2011 at 10:55 pm
I think Hugo said it best many pages ago, but it bears repeating. For every table in which you use a surrogate key, you should also have at least one...
January 8, 2011 at 11:43 pm
JJ B (10/25/2010)
And consider what so many people call a junction table - a table that represents the many-to-many relationship between two tables. I will usually model these as...
January 8, 2011 at 11:10 pm
1) Please keep in mind that this issue is a compounded one since a field can show up in other tables as well as using memory, CPU, network, log space,...
January 1, 2011 at 3:41 pm
If you ask your manager whether she'd rather wait 10 minutes for her answer, or 10 seconds, she's going to go for the 10 second option.
Of course this is...
January 1, 2011 at 2:59 pm
What is never mentioned in the article is "Scale to what point?". Let me demonstrate: You are using a bigint for a primary key on a table with a billion...
January 1, 2011 at 12:44 pm
Eric Russell 13013 (10/28/2010)
October 28, 2010 at 11:16 pm
Paul White NZ (10/26/2010)
Craig-315134 (10/26/2010)
It would seem there are now more posts on the subject of GUIDS than there are GUIDS. 😀
:laugh: Yes, this is always a hotly-debated topic. ...
October 26, 2010 at 10:29 am
Eric Russell 13013 (10/26/2010)
October 26, 2010 at 10:23 am
Jeff Moden (10/25/2010)
Thomas-282729 (10/25/2010)
It amazes me that top notch developers still try to prematurely optimize.
You and I may be talking about two different things. Doing it right to begin...
October 25, 2010 at 7:17 pm
Viewing 15 posts - 1 through 15 (of 74 total)