823 reputation
17
bio website valthor.net
location Reykjavik, Iceland
age 35
visits member for 1 year
seen 15 hours ago

13 years of coding PL/SQL, T/SQL, and managing Oracle and MSSQL servers in enterprise environments. Mostly finance and telco


Apr
9
answered How do I validate all my constraints in postgresql?
Apr
9
answered How to generate create table script without primary and foreign key in Oracle
Mar
26
awarded  Yearling
Oct
14
answered Pull every other row, starting at 0, and concatenate them together
Oct
14
answered Need to create combinations of Parents/Children/Dogs, but can't get past 2nd level of CTE
Oct
13
answered Avoiding table level locking
Sep
26
comment Oracle query is slower the second time
Are you using bind variables in your query ?
Jul
24
comment Bus time schedule database design
I think you are :-)
Jul
24
comment Bus time schedule database design
That's true, if you want to do measurements for analytical purposes, you need to register the times in a separate table. You could achieve this by adding this table : route_actual_times (route_start_time_id, line_stop_id, actual_time, ... )
Jul
24
comment Bus time schedule database design
But if you have a start time and a delta for each stop, you have the same data, you don't need to store the stop time for each route's stop. If you add each delta to the start time, you will get the bus stop time for each stop.
Jul
23
answered Bus time schedule database design
Jul
22
comment Query taking too long to execute
You should really include the CREATE TABLE statements for all tables included in your query
Jul
17
comment COUNT of rows with parent id equal to the row we have with a parent id of 0 in one query
Yes, you're right. The grouping is redundant
Jul
15
answered COUNT of rows with parent id equal to the row we have with a parent id of 0 in one query
Jun
4
comment Postgresql constrains on FK
Why do you have a problem with columns having NULL values? In this case they seem to do the trick quite nicely, even though perhaps in some strict sense of the theory, the table isn't normalized. However that's only true if you regard NULLs as actual values. Anyway, by using the structure mentioned above, you can always place a check constraint on the educationId (getting the type) and detail columns, forcing your mentioned business rules about which details follow which education type
Jun
4
answered Postgresql constrains on FK
Jun
3
answered Create database role to allow read access to all tables; write access to some
Jun
3
answered Design consideration regarding state handling: how to store multiple, variable states for one entity
Jun
3
comment Stored procedure not working
It would be helpful if you'd post the actual command throwing this error
May
24
comment Remove scientific notation from an XML column
That just depends on the input really, you have to have a look at the application code that's inserting the XML into the field.