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

38m
comment Retrieving n rows per group
See my edit to Mikael's answer for the reason for the extra logical reads associated with apply.
1h
reviewed Reviewed Mysql closing immediately after new installation
4h
reviewed Reviewed Full text search results in a large amount of time spent in 'FULLTEXT initialization'
4h
reviewed Delete Database cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery
4h
comment Database cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery
This is just a copy of another answer (which isn't correct).
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?
1d
awarded  Marshal
1d
answered Aggregation Operations on View Ignores Index
1d
reviewed Reviewed Cassandra Deployement Architecture
1d
revised Cassandra Deployement Architecture
Copy edit, in-lined image
1d
reviewed Close Graphical user interface to change data capture on Oracle