21,830 reputation
660124
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 3 years, 9 months
seen 6 hours ago

6h
reviewed No Action Needed What does the Postgres <-> operator do?
6h
revised Deleting duplicate rows with condition
deleted 20 characters in body; edited title
8h
comment T-SQL brain teaser: find non-overlapping sets
Please tag your question with the version (e.g. 2014) of SQL Server you are using. Also, are you looking to optimize for the minimum number of groups, the best balance of employees across groups, or something else?
8h
reviewed No Action Needed How to update a huge MySQL table from a text file
8h
reviewed Approve How to update a huge MySQL table from a text file
8h
reviewed Looks OK Problem in adding foreign key
9h
revised Enabling TDE without breaking existing mirror
Removed tag from title
9h
revised Improving the performance of STIntersects
Code formatting
10h
revised SQL Server Full Text Search - .rtf files incorrectly indexed by rtf tags
Fixed formatting
11h
revised Improving the performance of STIntersects
added 2 characters in body; edited tags; edited title
12h
reviewed No Action Needed To select from all tables inside the schema in PostgreSQL
12h
reviewed Close How to manage two tables in SQL Server
12h
reviewed Reject Can we migrate oracle database 10gR2 to cross platform
13h
reviewed No Action Needed Inserting a lot of big numbers into a mysql database
13h
reviewed Leave Open Sorting by two columns conditionally
13h
reviewed Leave Open Corrupt DB for a noob
13h
revised Sorting by two columns conditionally
added 361 characters in body; edited title
19h
reviewed No Action Needed tables relationships in database
21h
reviewed No Action Needed What is shared between two instances on the same server?
1d
reviewed No Action Needed How to create a temporary table using VALUES in PostgreSQL