21,057 reputation
761127
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 3 years, 9 months
seen 1 hour ago

2h
reviewed No Action Needed Update different oracle database from different oracle database
4h
reviewed Reviewed Email address unique or primary key?
4h
reviewed No Action Needed Why is Mongo stuck in STARTUP2?
7h
reviewed Approve DBO execute returns true but doesn't execute
8h
reviewed Close Split a row into multiple rows of one product
8h
reviewed Close ERROR log file size is expanding very fast because of the “ GHOST CLEANUP ” command
8h
reviewed Close The SQL server Log folder is expanding because of the SQL Dump files (what to do with it ?)
20h
revised Trouble setting up Nagios to monitor Oracle services
formatting
20h
reviewed Close Building a Database
20h
reviewed Looks OK Are there any good tools to convert mysqldump files to CSV?
21h
reviewed No Action Needed ubuntu - Pm2 mysql high cpu usage
21h
reviewed Close Best way to document Dwh views
1d
comment Retrieving n rows per group
See my edit to Mikael's answer for the reason for the extra logical reads associated with apply.
1d
reviewed Reviewed Mysql closing immediately after new installation
1d
reviewed Reviewed Full text search results in a large amount of time spent in 'FULLTEXT initialization'
2d
reviewed Reviewed Nosql multiple database design to handle sharing scenarios
2d
reviewed Leave Open Can I revert to local logging in IIS 7.5 if ODBC fails?
2d
reviewed No Action Needed Extract one MySQL database from a FULL MYSQL Server backup file
2d
comment Conversion of a varchar data type to a datetime data type resulted in an out-of-range value
Actually, I have been known to do exactly that :) And here's one example of why.
2d
revised Conversion of a varchar data type to a datetime data type resulted in an out-of-range value
Added D and T variants