Reputation
1,987
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
5 18
Impact
~98k people reached

1d
comment Spiky COMMIT results in performance slowdowns with Postgres 8.4
That is quite possible, but there are a lot of variables in play
1d
comment Code required to make column not nullable
Sure, alter is very safe, not sure why you'd doubt that
2d
comment Code required to make column not nullable
Looks like SSMS is programmed to re-create tables to change a column's nullability Perhaps they have a list of safe operations, and altering the nullability of a non-PK was not on it?
2d
comment Code required to make column not nullable
Can't imagine anything going wrong with alter table. Curious why SSMS thinks it has to alter all the other tables, when the referenced column is not changing!
2d
answered Spiky COMMIT results in performance slowdowns with Postgres 8.4
2d
comment MSSQL Query table returned all rows but keep executing for long time
You could performance test the virtual machine in terms of disk throughput? I'm no expert in that, but Google is your friend
May
20
comment MSSQL Query table returned all rows but keep executing for long time
About 30k rows of 5kb adds up to 150mb. That should not take 30 seconds even if it all has to come from disk. What kind of storage are you using? Are you on a virtual or cloud server?
May
20
comment Unable to delete Log Shipping configuration
Is that an Agent job? If so, can you copy a job from another database and fool the wizard into believing it does exist?
May
12
awarded  Popular Question
May
7
revised Converting outer apply with Correlated subquery in SQL Server to SQLite
Updated terminology from Ypercube's comment
May
7
answered Converting outer apply with Correlated subquery in SQL Server to SQLite
May
6
answered Create a grouping based on chains of pairs
May
4
comment Postgresql assign mutliple row query result to variable and continue execution
Yeah, functions continue after return. You can even use multiple returns, as long as they have the same recordset defintion
May
3
revised Postgresql assign mutliple row query result to variable and continue execution
deleted 191 characters in body
May
3
answered Postgresql assign mutliple row query result to variable and continue execution
Apr
23
comment What to do with WAL files for Postgres Slave reset
If you have a WAL achive, you can try restore_command as Craig Ringer suggests. The pg_basebackup creates an entirely new slave in an empty directory.
Apr
23
answered What to do with WAL files for Postgres Slave reset
Apr
23
comment What to do with WAL files for Postgres Slave reset
Could you post more of the logs, from where it starts to recover to the error? If it's a lot of text, you could link to pastebin.com
Apr
23
comment What to do with WAL files for Postgres Slave reset
What happens if you start the slave? Why can it not resume at the point where it stopped?
Apr
22
comment Anything like a hash for Postgresql databases?
We've got scripts that rely on exactly that and they've been working for years. Of course we might just be lucky. Do you have any sources to back your claim that the order of things in pg_dump is arbitrary?