Reputation
295
Top tag
Next privilege 300 Rep.
Create tags
Badges
4 14
Impact
~19k people reached

  • 0 posts edited
  • 0 helpful flags
  • 12 votes cast
Mar
24
awarded  Popular Question
Mar
19
awarded  Popular Question
Oct
6
comment Service Broker received an error message on this conversation
@RogerF.Wolf I technically don't have to. I ended up removing that validation to see if it was the problem; it wasn't. I do like the idea of having well-defined messages, though.
Oct
6
awarded  Notable Question
Sep
30
asked Service Broker received an error message on this conversation
Aug
20
comment Is there a means to set the owner of all objects in a PostgreSQL database at the same time?
Besides creating dynamic sql that you have to regurgitate, there is nothing "wrong" with his answer other than it being arguably more complicated; I have no power over your confidence, but after working with this rdbms for several years now, I definitely have confidence in it.
Aug
20
comment Is there a means to set the owner of all objects in a PostgreSQL database at the same time?
...and, apparently, updating the owner of all objects in a database, for which there is still not a practical means of doing, going on 3 years later. BTW, I have tested this in 8.4, 9.1, and 9.3, without issue. To the reader, YMMV, but it worked for me.
Aug
13
awarded  Popular Question
Jul
18
awarded  Popular Question
Jul
2
awarded  Curious
Jun
3
awarded  Notable Question
Oct
27
awarded  Popular Question
Sep
10
comment Cannot shrink transaction log
@AaronBertrand generally that's true but this literally gets written to once a week, in one transaction from one file; even if we lost a day's worth of data, we'd just re-import the file.
Sep
10
accepted Cannot shrink transaction log
Sep
10
comment Cannot shrink transaction log
Yeah I turned on autoshrink to see if it made a difference, and I'd already given up on point-in-time recovery at this point. Since the db is also fully backed up every day, I suppose it will not hurt to go to simple mode.
Sep
10
asked Cannot shrink transaction log
May
29
accepted Profiling a PostgreSQL function
May
29
asked Profiling a PostgreSQL function
May
29
asked Query result with X rows discarded
May
20
awarded  Caucus