Reputation
1,953
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
8 14
Newest
 Yearling
Impact
~77k people reached

Aug
21
answered Is Oracle more demanding environment for a DBA than SQL Server?
Aug
20
comment Is there a DBMS that allows the “= NULL” syntax?
Be aware that the ANSI_NULLS OFF option changes the meaning of certain expressions. You can break or change the behaviour of your code just by changing the ANSI_NULLS option. Also certain SQL Server features are disabled when ANSI_NULLS is OFF. ANSI_NULLS OFF is a deprecated feature and really should be avoided unless it's essential for backawards compatibility reasons.
Aug
14
answered When should you denormalize?
Aug
12
answered Policies RE database triggers in well-designed applications?
Aug
12
answered Suggestion for Large SQL Server Database Design
Aug
11
comment Guidance for using composite keys to identify rows
@X-Zero, I did make the point about foreign key references in my second para. The question as I read it is whether to implement the composite key, not whether also to have an auto-increment.
Aug
11
comment Why is it a bad practice to allow everyone to use the sa login?
Your applications do not require it. Please tell us why you think they do.
Aug
10
answered Guidance for using composite keys to identify rows
Aug
4
comment Why does = NULL not work in Oracle?
Oracle does not treat null as meaning that a value is unknown. Don't confuse the logical truth-value UNKNOWN with the missing value marker NULL - they are different things.
Jul
24
answered What are the alternatives for an ORDER BY clause in a View?
Jul
12
answered Pros/Cons Using multiple databases vs using single database
Jul
7
answered Which DBMS are fast enough for an online game (few thousand players)?
Jul
1
revised What are the top 5 design decisions which need to be made when implementing a database?
deleted 4 characters in body
Jul
1
answered What are the top 5 design decisions which need to be made when implementing a database?
Jun
29
comment What are some common and useful fields for a users table in a database?
Don't store password. Store the hash only.
Jun
29
comment MySQL: Why is auto_increment limited to just primary keys?
+1 for the fact that auto_increment isn't limited to PKs. Not sure why you think using negative numbers for a surrogate key leads to "huge problems" though.
Jun
29
answered MySQL: Why is auto_increment limited to just primary keys?
Jun
28
comment Can I losslessly decompose this table?
What are the key(s) in your original table? What dependencies is it supposed to satsify? You seem to be saying that child_id->parent_id, in which case child_id and parent_id cannot both be part of the same key in that table.
Jun
27
answered Fact table foreign keys null?
Jun
23
comment Cartesian Product SQL / Inserts with multiple Values Clauses
Technically a CROSS JOIN in SQL isn't the same as the Cartesian Product but CROSS JOIN may be what you want. A comma (,) is the alternative syntax that can be used instead of CROSS JOIN (not all SQL versions support CROSS JOIN but most do support the "comma join" syntax)