207 reputation
27
bio website highlycohesive.net
location Georgia
age 36
visits member for 3 years, 8 months
seen Jul 15 '11 at 13:59

Personally I find StackOverflow to be good for personal development. We should all spend some time trying to debug without a compiler. It's also good to challenge and debate methods. "Best Practice" isn't an answer to anything except perhaps "how do I code with the least effort, analysis, and thought possible?"


Aug
11
awarded  Notable Question
Jun
7
awarded  Yearling
Apr
5
awarded  Popular Question
Jul
15
accepted Add DEFAULT to existing column
Jul
14
awarded  Critic
Jul
14
asked Add DEFAULT to existing column
Jan
28
awarded  Scholar
Jan
28
accepted What's the best way to track Updated By, Updated On
Jan
27
answered How to dive into an ugly database?
Jan
26
awarded  Student
Jan
26
comment Estimate large database size and speed
"go try it" is effectively the same as "I don't know." -- Ah, no. "Go try it" is me telling him to not rely on internet opinions for something like determining if there's a performance issue with a given dataset, database, and server. No way am I going to write an entire app just trusting that someone has had an experience that worked fine. Things like server size, data distribution, other databases on the same server, etc. matter.
Jan
26
awarded  Teacher
Jan
26
comment MySQL data type for 128 bit integers
I can't help but notice this is the second question where it looks like you're having to do weird things with your solution in order to be able to use MySql. Have you considered a more robust DB platform?
Jan
26
comment Estimate large database size and speed
Granted, it doesn't just answer the question -- but there's really no other way to know for sure when it comes to things like "will this run well" than to do a little proof of concept evaluation.
Jan
26
answered Estimate large database size and speed
Jan
26
comment What is a Clustered Index?
I hear what you're saying. The problem is not with your answer per-se, but in the fact that less experienced people than yourself run around quoting and applying something because it's "best practice" without understanding the use and context the best practice was written for -- I'd argue that yes, we're here to educate and that quoting best practice without providing more context directly in the post doesn't do as good of a job of that.
Jan
26
comment What is a Clustered Index?
I didn't say faster. A covering index has all the data requested in the select in the index - IN ORDER, on a separate location on the disk. So a select against a matching covering index never hits the table.
Jan
26
awarded  Autobiographer
Jan
26
asked What's the best way to track Updated By, Updated On
Jan
26
comment What is a Clustered Index?
Non clustered indexes can be just as efficient for lookups, if the non-clustered index is covering for the lookup in question.