| bio | website | spencerandbrown.com/mbb |
|---|---|---|
| location | Nashville, TN | |
| age | 37 | |
| visits | member for | 2 years |
| seen | May 15 at 20:12 | |
| stats | profile views | 6 |
I'm just some guy, you know?
|
Apr 25 |
comment |
Why is naming a table's Primary Key column “Id” considered bad practice? No. In your example I would probably have a CompanyOfficer or CompanyPerson table which allows a many-to-many relationship with between Company and Person with additional information about the nature of the relationship. If I were to implement it within the Company table, I would use the column names PresidentPersonID and TreasurerPersonID to preserve the *PersonID part of the name while adding the additional descriptor. inner join Person as Presidents on Company.PresidentPersonID = Presidents.PersonID |
|
Oct 18 |
comment |
How do I dual license? @cyco130 if you posted your comment as an answer, I would upvote it as hard as I possibly can. |
|
Oct 18 |
answered | Why is naming a table's Primary Key column “Id” considered bad practice? |
|
Oct 3 |
comment |
Why is software still released with known bugs? Related to this is the fact that every bug fix creates the opportunity to introduce new bugs in the product which can be more serious than the original bug. |
|
Sep 29 |
awarded | Commentator |
|
Sep 29 |
comment |
How can dev teams prevent slow performance in consumer apps? The key point here is that for most consumer applications, performance is not a feature that sells software. It's not something that looks shiny in the checklist of "Things this software does." Computer games are a shining example of this thinking. The system requirements for games has steadily increased over time, meaning that new games are slower with the same hardware you had before, because a higher framerate is not going to move that box off the shelf, but realistic environments rendered in real time with fractal detail will... |
|
Sep 26 |
comment |
How do you share your craft with non programmers? I am a fan of using bad analogies to explain esoteric concepts. |
|
Sep 20 |
comment |
How do I convince my fellow devs to WANT to add comments to source code commits? "Make them...deal with support." is the winner for me. After having supported a legacy product for a few years, I cannot bring myself to commit code without some kind of comment. |
|
Sep 19 |
awarded | Critic |
|
Sep 15 |
answered | If the purpose of a single complicated LOC is clear, would you bother to split it on to multiple lines to make its method clear as well? |
|
Sep 15 |
comment |
Sequel vs S-Q-L I believe this is also related to the fact that QUEL was the name of the other prominent query language back in the dark ages of RDBMS evolution. en.wikipedia.org/wiki/QUEL_query_languages |
|
Sep 7 |
answered | How do you refrain from doing too much when maintaining code? |
|
Aug 25 |
revised |
The worst anti-patterns you have came across added 21 characters in body |
|
Aug 25 |
answered | The worst anti-patterns you have came across |
|
Aug 25 |
revised |
The worst anti-patterns you have came across added 122 characters in body |
|
Aug 25 |
answered | The worst anti-patterns you have came across |
|
Aug 25 |
answered | The worst anti-patterns you have came across |
|
Aug 25 |
comment |
The worst anti-patterns you have came across Not doing anything is not always the worst case scenario. Sometimes it's better to have to write it from scratch than to have code to rewrite... |
|
Aug 25 |
comment |
The worst anti-patterns you have came across Why do you have to bring up these buried memories? I was having such a nice day. |
|
Aug 24 |
awarded | Teacher |