363 reputation
111
bio website
location Bergen, Norday
age 27
visits member for 2 years, 1 month
seen Mar 3 at 8:50

Worked as a TA in a database fundamentals course in university, so when I graduated and started working as a web developer at an IT company without a DBA, it was natural that I'd end up stumbling into the role of accidental DBA.


Jul
2
awarded  Curious
Jun
12
awarded  Popular Question
Jun
4
awarded  Popular Question
Jan
12
comment ALTER DATABASE statement not allowed within multi-statement transaction
"perhaps you pasted the script into a query window that already had an active transaction" That seems to have been the problem, because when I ran the whole query in a new window, it worked.
Jan
12
accepted ALTER DATABASE statement not allowed within multi-statement transaction
Jan
10
asked ALTER DATABASE statement not allowed within multi-statement transaction
Dec
4
awarded  Popular Question
Nov
5
awarded  Popular Question
Jun
5
awarded  Yearling
Feb
10
suggested suggested edit on Delete with subquery with no unique columns
Feb
10
comment DB2 error - SQL Statement too long or complex
Could you specify something more about where these values are coming from, how the query is built, used, etc.? It might be useful to know more about the problem domain.
Feb
10
revised DB2 error - SQL Statement too long or complex
added 163 characters in body
Feb
10
answered DB2 error - SQL Statement too long or complex
Feb
10
comment What relationship type to use for this messaging system?
You're welcome! I might not be an expert on DBA things, but TAing a university course on database fundamentals with a strong focus on taking a spec and turning it into a functioning database via an EER model and a relational model did at least leave me prepared for questions like this ;)
Feb
10
revised What relationship type to use for this messaging system?
Changed some of the table aliases to be more readable
Feb
10
answered What relationship type to use for this messaging system?
Jan
30
answered Select query from two tables which only specified rows
Jan
23
comment does a subquery pull the entire table?
You could do an EXPLAIN to see what's happening "under the hood". Edit: you don't mention which DBMS you're using, so I can't link to any documentation about how your DBMS uses EXPLAIN.
Jan
19
comment Question regarding 2NF partial key dependency
Can't BC->D be shortened to C->D since AB->C?
Jan
18
comment Slow Query Gets Even Slower After Indexing
Do you know if adding a UNIQUE index on (from_field, to_field) would have any impact on the query compared to using LIMIT 1?