741 reputation
38
bio website
location
age
visits member for 2 years, 7 months
seen Nov 24 at 13:36

Jul
11
answered Slow DELETE in MySQL with a subquery
Jan
16
answered SQL Server auto-trim of varchar value in equal comparison but not like comparison
Aug
16
answered Relations, dependencies and normal form
Apr
10
answered Column partially determining accepted values of another column, should be somehow normalized?
Apr
3
answered What happens to a Trigger if a table is dropped and rename and recreated with same name
Mar
12
answered Performing SELECT on EACH ROW in CTE or Nested QUERY?
Mar
2
answered Why is optimistic locking faster than pessimistic locking?
Feb
19
answered Database functional dependency BCNF help
Feb
19
answered Multiple primary keys
Feb
14
answered Where can I find the SQL standard document?
Jan
29
answered Looking for a scalable relational database
Jan
23
answered Reflexivity axiom for inferring functional dependencies
Dec
14
answered Simplify and optimize a complex query
Oct
8
answered Merging tables with a 1 to 1 relationship in a database
Oct
4
answered Database table and NULLs
Oct
4
answered Why does ANSI SQL define SUM(no rows) as NULL?
Sep
11
answered Need to add a Table Level Constraint to prevent bad data - Constraint is not working
Sep
11
answered Are there DBMS that allow a Foreign Key that References a View (and not only base tables)?
Sep
11
answered WHERE clause is not filtering on LESS THAN and GREATER THAN or BETWEEN
Sep
10
answered How do I get the current and next greater value in one select?