Reputation
15,355
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
2 28 53
Newest
 Electorate
Impact
~1.1m people reached

May
27
reviewed Leave Open SSMS Intellisense - Data Dictionary Incorporation - Show Object Descriptions in Popup?
May
27
comment 00911. 00000 - “invalid character”
Oh, it's simple. Split your DDL statements up so they are individual execute immediates, and ditch the semi-colons
May
26
comment Why OEM RMAN backup jobs fail after changing the preferred credentials?
Did you check the host (ssh) passwords as well as the database ones? Really pisses me off when "expert" security bods in corporations enforce password changes on service accounts. Utterly pointless.
May
26
reviewed No Action Needed My auto increment primary key is not automatically incrementing
May
26
reviewed No Action Needed SSMS Intellisense - Data Dictionary Incorporation - Show Object Descriptions in Popup?
May
26
reviewed Reviewed Reset every Oracle sequence to the MAX value of its target table PK?
May
25
reviewed Close Is this many to many relationship correct?
May
25
reviewed Close Will performing a physical copy of a MySQL database on Windows to a MySQL instance on Linux still perform?
May
25
reviewed Leave Open Fetch all parents from child id
May
24
comment Fetch all parents from child id
Recursively, or not?
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