20,867 reputation
459113
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 3 years, 8 months
seen 8 hours ago

Jul
30
reviewed Reject suggested edit on Relationships between subtypes of an entity
Jul
30
reviewed Approve suggested edit on importing MySQL dump to SQL Server 2012
Jul
30
revised Index seek much slower with OR condition compared with separate SELECTs
Improved title and tags
Jul
30
comment Index seek much slower with OR condition compared with separate SELECTs
I have added my answer to yours, David. Feel free to roll it back if you disagree, and I will reinstate my answer.
Jul
30
revised Index seek much slower with OR condition compared with separate SELECTs
Incorporated my answer
Jul
30
reviewed Reject suggested edit on How to minimize the writes needed to update a counter field multiple times
Jul
29
reviewed Approve suggested edit on Problems with foreign keys in a mysql database
Jul
29
reviewed No Action Needed Optional oneToOne relations and criteria field
Jul
29
reviewed Reviewed Replication of a remote MySQL database to local MySQL database
Jul
29
reviewed Reviewed Using MySQL Workbench, what is a good way to do development on an alternate server and copy changes to the main server?
Jul
29
reviewed Looks OK Full Text Search With PostgreSQL
Jul
29
reviewed No Action Needed SQL Server 2012 installation silently fails
Jul
29
awarded  Revival
Jul
29
reviewed No Action Needed Connect to Oracle DB 9i using SSH TUNNEL via putty
Jul
29
reviewed Reviewed Difficulty getting sp_executesql to work
Jul
29
comment Difficulty getting sp_executesql to work
You can't use dynamic SQL in a function.
Jul
29
answered Side effects of using updlock lock hint?
Jul
29
reviewed No Action Needed MySQL Optimisation
Jul
29
reviewed No Action Needed MySQL - grant all privileges on *.* brings back Access denied
Jul
29
reviewed Reviewed Index that is not used, yet influences query