367 reputation
111
bio website
location Austin, TX
age
visits member for 2 years, 11 months
seen Oct 9 at 17:45

Sep
30
awarded  Explainer
Feb
26
comment how determine the best path that satisfies a condition
That presumes that the P value needed for the real-world problem is accurately represented by poster's example. It may be simplified, as such examples often are. But yes, for OP's sake, hopefully it's a manageable amount of brute force.
Feb
26
answered how determine the best path that satisfies a condition
Feb
20
comment Database throughful design vs Quick and dirty design comparison
+1 Decomposing addresses is sufficiently difficult that even end users, who only have to do it to a single address, will often make mistakes in the process. Then you get the City in Street, while the Street is in StreetNumber along with the Number (because you had to make that field long enough to deal with weird numbering schemes like Tokyo) and in the end what you get is garbage in, garbage out. It's far easier to treat the address as a heap of data, breaking out only the postal code. Scrub & validate the heap as needed, and let the code do the heavy lifting.
Feb
18
comment How can I dynamically alias columns?
Bear in mind that if you are accepting user input and using it to build dynamic SQL, then you really, really need to be concerned about SQL injection and sanitizing inputs. bobby-tables.com
Jan
21
answered Multiple relationships between the same entities
Jan
21
awarded  Organizer
Jan
21
revised Bring relevant results based on an input search query - full text search?
Spelling fixes, make headline more specific, add DBMS tags
Jan
21
suggested suggested edit on Bring relevant results based on an input search query - full text search?
Jan
13
comment How to make stored procedures more readable without harming performance
It would help if you clarify the question by giving the specific qualities that make them "unreadable". It sounds like you are concerned with more than just overall length.
Jan
13
comment How to create a trigger that update the date and time field and modify of the row
Not only do you not need a trigger for this, a trigger would be an incredibly ill-advised solution here. I just had a brief nightmare of someone putting a WAITFOR inside of a trigger. Just in case someone reads this thread and thinks "Well, he didn't need a trigger but he could have used one", let me be clear: Triggers are for doing instantaneous operations against the data Inserted and/or Deleted; they are not for anything that involves waiting or scheduling. Down that road lies the path to performance hell.
Dec
13
awarded  Yearling
Dec
22
comment Writing a simple bank schema: How should I keep my balances in sync with their transaction history?
@NickChammas /me heads off to close his account at BofA. ;-)
Dec
22
comment Writing a simple bank schema: How should I keep my balances in sync with their transaction history?
You know, normally people ask on StackExchange "Is this homework?" because they don't want it to be. But, since you're doing a bank schema from scratch, I really, really hope for your sake that this is homework. :D Either way, it should be a great lesson in proper ACID transaction design.
Dec
21
awarded  Quorum
Dec
21
comment SQL Server reports for management
@jcolebrand I'm judging the breadth of the question, not the ability of the person. I am sure Alex is capable & smart & will make a great DBA. But I wouldn't regard a simple list of trackables as an upvote-worthy answer. There's no report that spits out a "Your database is healthy" message. If I say "Monitor the Disk Queue Length" to someone new to the field, I'm going to be saying it as a lead-in to a larger discussion of benchmarking and profiling and understanding what that datum means. "Health" is not just about having an EKG machine, it's about reading what it is telling you.
Dec
21
revised Joining two tables on multiple criteria
added OP's description of attempted solution thus far
Dec
21
awarded  Commentator
Dec
21
suggested suggested edit on Joining two tables on multiple criteria
Dec
21
comment Joining two tables on multiple criteria
Welcome to DBA.se. Your questions will typically get better answers and more votes if you include information on what you have already tried, which is why JNK asked. I'm editing your response into the question. Also, if your question is for a specific database server (e.g. Oracle, SQL Server) it is a good idea to put that in the question and in the tags. Which RDBMS are you targeting?