Reputation
8,942
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
4 23 48
Impact
~450k people reached

Aug
7
reviewed Reviewed How to resolve “the specified account already exists” error during SQL Server 2008 R2 installation
Aug
7
revised How to resolve “the specified account already exists” error during SQL Server 2008 R2 installation
edited tags
Aug
7
reviewed No Action Needed Any SQL where clause performance similar to where 1=0
Aug
7
reviewed Reviewed Min(date) in sum case statement
Aug
7
revised Min(date) in sum case statement
added 56 characters in body; edited tags
Aug
7
reviewed Reviewed simple mysql query design help
Aug
7
comment simple mysql query design help
Check out how to pivot. There are many examples here: dba.stackexchange.com/questions/tagged/pivot+mysql
Aug
7
comment How to call Oracle Function from POSTGRESQL
I am not exactly sure how to do it, but I think you could write a pl/python function (other untrusted languages might fit, too) to achieve it. You could also try github.com/atris/JDBC_FDW - again, not sure if it can help (what I read there, it should, but never tried).
Aug
6
revised is it “bad” to bulk update a boolean column semi-regularly on potentially a large set of records in Postgres?
added 4 characters in body
Aug
6
comment is it “bad” to bulk update a boolean column semi-regularly on potentially a large set of records in Postgres?
In a scheduled job I wouldn't use VERBOSE with VACUUM ANALYZE as there are chances that nobody, ever checks the output...
Aug
6
revised Last user update for a table
edited tags
Aug
6
reviewed Reviewed Last user update for a table
Aug
6
comment Last user update for a table
Which RDBMS are you on?
Aug
6
revised Last user update for a table
deleted 1 character in body
Aug
6
revised netezza wiki excerpt
added 3 characters in body
Aug
6
revised Columns names are case sensitive on postgres
added 33 characters in body; edited tags
Aug
6
reviewed Close When backup a database
Aug
6
reviewed Close Mysql transaction READ REPEATABLE and READ COMMITTED read view
Aug
6
reviewed Edit Weird Syntax Error
Aug
6
revised Weird Syntax Error
deleted 569 characters in body