361 reputation
312
bio website
location Bergen, Norday
age 28
visits member for 2 years, 5 months
seen Sep 16 at 10:32

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.


Nov
12
awarded  Notable Question
Sep
24
awarded  Autobiographer
Sep
21
awarded  Taxonomist
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