Reputation
7,591
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
3 18 42
Newest
 Revival
Impact
~345k people reached

Apr
29
reviewed Close Invalid use of side-effecting operator 'INSERT EXEC' within a function
Apr
29
reviewed Close how to import mysql system “mysql” database
Apr
26
reviewed Leave Open Easier way to handle so many isnull() situation
Apr
26
reviewed Close mysql replica ignoring server-id
Apr
25
reviewed Reviewed Transactional Replication Concerns
Apr
25
reviewed No Action Needed Extract part of string based on nth instance of character
Apr
25
awarded  Popular Question
Apr
25
reviewed Edit Can view adapt to implicitly reference user's default schema?
Apr
25
revised Can view adapt to implicitly reference user's default schema?
added 2 characters in body
Apr
25
comment Can view adapt to implicitly reference user's default schema?
Paddy, please explain why would this work. Thanks!
Apr
25
revised “Rewinding” a Postgresql database
adding link to docs
Apr
25
comment How to allow a user to create databases only with a certain prefix?
+1 as this is the answer I was lazy to write :) On the other hand, I see the CREATE/DROP DATABASE exception a quite logical choice. Encasing it in a transaction could raise quite a few interesting effects.
Apr
25
answered Creating a PostgreSQL SERIAL column using pgAdmin3
Apr
24
reviewed Close speed up data transfer from SQL server to application
Apr
23
comment Storing data as rows as opposed to columns
Think about it: how do you reconstruct a users data with this design (called EAV), compared to a traditional users table? This design has its use cases though.
Apr
23
reviewed Reviewed Optimize UNION query in MySQL
Apr
23
reviewed No Action Needed How can Innodb ibdata1 file grows by 5X even with innodb_file_per_table set?
Apr
23
reviewed No Action Needed Optimize UNION query in MySQL
Apr
23
reviewed Leave Open T-SQL Issues With Defining 'AS'
Apr
23
reviewed Close Getting sql statement to refer to more than 2 tables?