13,594 reputation
12048
bio website google.com
location Manchester, United Kingdom
age 36
visits member for 2 years, 6 months
seen yesterday

Oracle DBA, Unix admin.

Available for employment! ;)


Jun
19
reviewed No Action Needed SQLite and Write Ahead Logging: why so large files
Jun
18
reviewed No Action Needed selecting rows that have n foreign key conditions satisfied
Jun
18
awarded  Nice Answer
Jun
18
comment Debugging long Oracle queries and identifying offending data for 'Expression type does not match a required type' error
You could select via a cursor, iterate over the rows, catch the exception in a block & print the rowid of the offending row
Jun
18
reviewed No Action Needed Lock rows for long running transactions
Jun
18
reviewed Looks OK How to find the same salaries and department names?
Jun
18
reviewed Reject suggested edit on How to run SQL Job only on primary replica in AlwaysOn Availability Groups?
Jun
18
reviewed Close setting auto-increment value of primary key to maximum in postgre sql
Jun
18
reviewed Close How to use DAY/WEEK/MONTH/YEAR constant as parameter in stored procedure?
Jun
17
reviewed No Action Needed Datastructure to save relations between more than two entities and lists
Jun
17
reviewed No Action Needed sysadmin security error creating Reporting Services cache refresh plan in Report Manager
Jun
17
reviewed Leave Open Understanding execution plans using TVPs
Jun
17
reviewed Close How can a dba at a non-profit heathcare SMB use existing customer data to find out information about potental customers?
Jun
17
comment How to reference a table from another schema inside a package?
@miracle173 this seems to trip all new DBAs up. Remember crying over it myself 15 years ago :)
Jun
17
awarded  Generalist
Jun
17
reviewed No Action Needed Database slowdown at random times using mirroing
Jun
17
reviewed No Action Needed An efficient way to compare two large data sets in SQL
Jun
17
reviewed Leave Closed want to download 3GB database table from my development mysql server
Jun
17
reviewed No Action Needed Identify SQL Server Version in TSQL
Jun
17
reviewed No Action Needed Replication successful but slave skips certain quries