Reputation
15,286
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
1 27 53
Newest
 Reviewer
Impact
~1.1m people reached

May
24
reviewed Close Preventing unique key constraint violation when pre-existing row has 'expired'
May
24
revised SQL Server 2012 performance degradation
Fixed title, tagged
May
23
reviewed No Action Needed MySQL Cluster management node does not start (node has different checksum)
May
23
reviewed Close Deadlock on Delete Statement
May
23
comment How to use variable and drop in test script?
You can use any DML ("SQL"), and DDL within execute immediate. You just can't use explicit DDL within PL/SQL blocks.
May
23
revised How to use variable and drop in test script?
added 134 characters in body
May
23
answered How to use variable and drop in test script?
May
23
reviewed Leave Open How to improve this query performance by indexing properly?
May
23
answered Dual table default value?
May
23
comment Percona Toolkit Installation Error
@Peter The original poster is asking you for more information to clarify your answer
May
22
reviewed No Action Needed How can I minimize the risk of accidentally modifying the wrong database?
May
22
reviewed Approve Remove a period if it is the first character in a varchar column
May
22
comment Remove a period if it is the first character in a varchar column
Easy to do using a case statement and substring()/len(), surely?
May
22
reviewed Leave Closed How to identify the creator of the temporary table in SQL Server 2005
May
22
reviewed Approve Why is InnoDB waiting for table metadata lock in simple INSERT/DELETE + SELECT?
May
22
reviewed No Action Needed UPDATE Query replacing string primary key taking days to resolve
May
22
reviewed No Action Needed Intentionally recursive instead of insert trigger does not want to nest
May
22
reviewed No Action Needed Trigger to audit table changes
May
22
reviewed No Action Needed Schema for dynamic number of attributes
May
22
reviewed No Action Needed SQL Question: Selecting different language versions based on availability