FrustratedWithFormsDesigner

less info
2,564 reputation
613
bio website
location
age
visits member for 2 years, 6 months
seen 2 days ago

Aug
5
answered Creating a table with many optional fields
Aug
5
comment Database design for a table with both bulk insert and single row insert
@Munchi: Agreed, Oracle SQLLoader might be an excellent choice. Got any links with hard numbers on how it compares to bulk inserts?
Aug
1
answered Give every user 3 default 'bookmark' entries
Jul
16
comment How to model when you could have many (thousands of) attributes to a table (product)?
@ToC: What do the other dependencies look like? What, exactly, are you having trouble with? Entity-Attribute-Value systems are not new, but they can be tricky to work with. Is there a specific problem that you're having difficulties with?
Jul
16
revised How to INNER JOIN and OUTER JOIN within the same table?
added 51 characters in body
Jul
16
comment Stored Procedure slow after weekend
That sounds like how I feel on a Monday before I've had a chance to get some coffe! ;) ...seriously though, it sounds like some data might be cached but gets dropped from the cache over the weekend, maybe to make room for something else?
Jul
16
comment How to model when you could have many (thousands of) attributes to a table (product)?
@Colin'tHart: Perhaps you could write a full answer with a better solution. ;)
Jul
10
comment Wildcard subnet mask for IPv6
@NeilMcGuigan: I'm guessing that Colin probably thinks this is possibly off-topic because the IPv6 equivalent for 0.0.0.0/0 is going to be the same whether you're administering a database or writing a chat program, or something else.
Jul
10
comment Best table name instead of “user”, if the DB doesn't like that
This could be a problem when working with developers who know nothing about Irish/French/German/Hunrarian/Croation. The Irish and French I could probably guess at, but the Croatian one I'd never guess what it was just by looking at the name.
Jul
10
answered Best table name instead of “user”, if the DB doesn't like that
Jul
8
reviewed Edit suggested edit on Divide single column value into multiple column depending upon the bit value of another column
Jul
8
revised Divide single column value into multiple column depending upon the bit value of another column
improved formating, tags added
Jul
7
comment Oracle right outer join SELECT statement with a table
In the future, please also include what the exact problem is. Did you get an error code? Did the output look wrong? etc...
Jul
7
revised Oracle right outer join SELECT statement with a table
formatted query
Jul
7
revised How do I add versioning to this CMS I'm designing?
edited tags
Jul
4
revised Query with dynamic ranges in PostgreSQL based on status
edited tags
Jul
4
revised Personal and Global messaging database design
formatting
Jul
3
revised Is there a good way to select a row where the key represents the lower bound of a range?
formatting
Jul
2
revised Duplicate Relationships in Rails/MySQL Healthcare Application
edited tags
Jul
2
answered One table with a flag or two tables