user avatar
user avatar
user avatar
onedaywhen
  • Member for 10 years, 8 months
  • Last seen more than 2 years ago
12 votes

Does it make sense to use SQL Server's bracket notation in hand written code?

12 votes

Pattern matching with LIKE, SIMILAR TO or regular expressions in PostgreSQL

12 votes

Why aren't primary key / foreign key matches used for joins?

11 votes
Accepted

Implementing a one to zero or one relationship in SQL

6 votes

How to implement a 'default' flag that can only be set on a single row

6 votes

ERD directly producing 5NF relational schema - is this desirable?

6 votes

What is the difference between an INNER JOIN and an OUTER JOIN ?

6 votes

What computations can NOT be performed in standard SQL?

6 votes

How far should you go with normalization?

6 votes

What is the F301: the CORRESPONDING clause in query expression?

5 votes
Accepted

Database normalization: Describing trait - foreign key to table, or varchar field with value?

5 votes
Accepted

Definition for "logical difference"?

4 votes

How to express this constraint in a database schema?

4 votes

What Is The Point of a Primary Key?

4 votes

Pioneers in Database Research

4 votes

Is normalization process needed?

4 votes

6th normal form, recomposition query, efficient implementation

4 votes

Design: How do you decide when items are related vs when they are attributes?

4 votes

Theta join explanation

4 votes

How to maintain referential integrity of an object graph when a node is deleted

4 votes

Are there any good reasons for keeping date and time in separate columns?

3 votes

Perform UNION ALL regardless of column order in the two joined tables

3 votes

Comparing Columns that can contain NULLS - is there a more elegant way?

3 votes
Accepted

Milliseconds to datetime

3 votes

FK on NON Primary Keys

3 votes

Should I use a Column naming convention or rely on column descriptions?

3 votes

How to implement a 'default' flag that can only be set on a single row

3 votes
Accepted

How to express this constraint in a database schema?

2 votes

Type safety in WHERE clauses

2 votes

Primary Key on a View