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

2h
revised Trouble setting up Nagios to monitor Oracle services
formatting
2h
reviewed Close Building a Database
2h
reviewed Looks OK Are there any good tools to convert mysqldump files to CSV?
4h
reviewed No Action Needed ubuntu - Pm2 mysql high cpu usage
4h
reviewed Close Best way to document Dwh views
6h
comment Retrieving n rows per group
See my edit to Mikael's answer for the reason for the extra logical reads associated with apply.
7h
reviewed Reviewed Mysql closing immediately after new installation
9h
reviewed Reviewed Full text search results in a large amount of time spent in 'FULLTEXT initialization'
1d
reviewed Reviewed Nosql multiple database design to handle sharing scenarios
1d
reviewed Leave Open Can I revert to local logging in IIS 7.5 if ODBC fails?
1d
reviewed No Action Needed Extract one MySQL database from a FULL MYSQL Server backup file
1d
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.
1d
revised Conversion of a varchar data type to a datetime data type resulted in an out-of-range value
Added D and T variants
1d
awarded  Revival
1d
reviewed Reject index-tuning tag wiki excerpt
1d
reviewed Reject index-tuning tag wiki
1d
answered Converting a Unicode value to a non-Unicode value (SQL Server)
1d
reviewed Close Tables for library management system?
2d
awarded  Marshal
2d
answered Aggregation Operations on View Ignores Index