2,584 reputation
614
bio website
location
age
visits member for 2 years, 9 months
seen yesterday

Nov
13
revised Autoincrement Primary Key For Constants
added 24 characters in body
Nov
13
revised Need help designing a database
edited body
Nov
11
answered Design: Fitting variable hierarchy of text files into a relational db
Oct
31
comment Using Case in SQL
This looks suspicious: SUM(CASE WHEN financialinst.name <> 'National Financial Services'THEN Asset.Value END) What happens when the WHEN condition fails? Will SUM work ok on NULL values? Because I'm pretty sure that NULL<>0...
Oct
31
comment Using Case in SQL
What syntax error are you getting?
Oct
31
reviewed Approve suggested edit on Using Case in SQL
Oct
23
comment No-SQL Database Design for restaurant app
Do you have some understanding of how your NoSQL database works? What have you come up with so far?
Oct
7
comment Help in designing mysql table for large project
There's good arguments for your first solution (called a "multi-tenant" database) and your third solution. It's hard to know exactly what is better withouth knowing your requirements better.
Oct
7
revised Help in designing mysql table for large project
formatting
Sep
30
awarded  Explainer
Sep
11
reviewed Approve suggested edit on DB2 - how to safely blow away database on linux?
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.