Reputation
32,407
Next tag badge:
978/400 score
80/80 answers
Badges
8 82 137
Newest
 sql
Impact
~1.0m people reached

Nov
9
revised Could Oracle ORA-08103 'object no longer exists' error be caused by size of undo_retention parameter?
error correction
Nov
9
reviewed Approve Why is DBA_SEGMENTS presenting twice the amount of data than the DBA_TABLES?
Nov
6
reviewed Approve Help to create indexes to improve query performance and reduce report generation time
Nov
5
comment MERGE with OUTPUT doesn't seem to be doing the right thing
@thecoop - It allows you to access the "before" and "after" values for an update. Conceptually you might consider an update to be a delete followed by an insert even though that often isn't how it actually happens.
Nov
5
comment Performance of SQL Server Triggers
SQL Server has INSTEAD OF triggers that can be applied to tables. Not sure how similar that is to before update triggers?
Nov
5
reviewed Approve Pivoting row contents to produce one dimensional result
Nov
5
reviewed Approve How to search with partitions in my query?
Nov
4
reviewed Reviewed MySQL : DROP TABLE Starting with a Prefix
Nov
4
reviewed Reviewed How to measure improvement after splitting tablespaces into multiple disk volumes? (Oracle 10g AWR)
Nov
4
reviewed Close MySQL detect duplicate human names
Nov
4
reviewed Close Are there any guidelines for the “IBM Premier Level Business Partner”?
Nov
4
reviewed Close Why we use low numbers for concurrent in MySQL benchmarks or HTTP_LOAD?
Nov
4
reviewed Close How to convert data from XML format into Excel workbook or database table
Nov
4
reviewed Close seeking a confirmation — SQL Server backup performance
Nov
4
reviewed Reviewed Sybase anywhere sql server connection problems
Nov
4
reviewed Reviewed How to create sql query results in columns from rows?
Nov
4
reviewed Reviewed List primary keys for all tables - Postgresql
Nov
4
reviewed Approve sybase tag wiki
Nov
3
reviewed Approve I get ORA-13605 when trying to run SQL Tuning Advisor from SQL Developer
Nov
3
revised SQL ANSI JOIN precedence
added 205 characters in body