12,625 reputation
12048
bio website
location Munich
age
visits member for 3 years, 6 months
seen 19 mins ago

Nov
16
comment Table design for optimum performance
You should never mix different types of information into a single column, not even "hypothetically". Especially your third query will benefit from properly putting the gender into its own column (you can do an equality on the gender column rather than needing a LIKE query on the EmployeeID column)
Nov
16
revised where in (sub query) vs join
edited tags
Nov
16
comment where in (sub query) vs join
Which DBMS are you using? Most query planners are smart enough to apply such a transformation for you (if possible). And a join is not necessary a replacement for an IN condition because the join might return multiple rows where the IN would only return a single row.
Nov
15
comment When using underscores, should they be reserved to junction tables?
According to the SQL standard CompanyType will be stored as COMPANYTYPE because all non-quoted identifiers must be converted to uppercase. Therefore it's better to use "snake case": COMPANY_TYPE
Nov
14
revised hierarchical-queries wiki excerpt
Hierarchical queries are not limited to Oracle. Added the reference to standard recursive CTEs
Nov
14
revised hierarchical-data wiki description
added 1062 characters in body
Nov
14
revised hierarchical-data wiki excerpt
added 285 characters in body
Nov
14
revised hierarchical-queries wiki description
Hierarchical queries are not limited to Oracle. Added the reference to standard recursive CTEs
Nov
14
reviewed Approve suggested edit on Restoring master database
Nov
14
revised List two columns - MYSQL
added 23 characters in body
Nov
14
wiki created hierarchical-data description
Nov
14
wiki created hierarchical-data excerpt
Nov
14
suggested suggested edit on hierarchical-data tag wiki
Nov
14
suggested suggested edit on hierarchical-data tag wiki excerpt
Nov
14
revised Get child record from specific root
edited tags
Nov
14
suggested suggested edit on hierarchical-queries tag wiki
Nov
14
suggested suggested edit on hierarchical-queries tag wiki excerpt
Nov
14
comment SQL Server: performance of IDENTITY vs INT as primary key
An identity column is an integer column.
Nov
14
revised Is it normal to hard code the input of over 80 input fields?
edited tags
Nov
14
reviewed Edit suggested edit on Cannot drop a Postgres table