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

12h
revised Using Netscaler datastream and MySQL
formatting, typos, removed sign-off
18h
revised Can a temporary table be shared across sessions?
deleted 12 characters in body; edited tags; edited title
1d
revised Selecting minimum value in top grouping only
edited tags
1d
revised Reasons for avoiding large ID values
edited tags
1d
revised How to find the SQL statements that caused tempdb growth?
Copy edit
1d
revised MySQL - Alter table to automatically put in a UUID
added 4 characters in body
1d
revised Effects of turning the transaction safety OFF
edited tags
1d
revised use an Index correctly to optimize queries
edited tags
1d
revised Multi-row insert vs multiple single row inserts
In-lined link, corrected typos, removed intro.
2d
revised Deleting duplicate rows with condition
deleted 20 characters in body; edited title
2d
revised Enabling TDE without breaking existing mirror
Removed tag from title
2d
revised Improving the performance of STIntersects
Code formatting
2d
revised SQL Server Full Text Search - .rtf files incorrectly indexed by rtf tags
Fixed formatting
2d
revised Improving the performance of STIntersects
added 2 characters in body; edited tags; edited title
2d
revised Sorting by two columns conditionally
added 361 characters in body; edited title
Dec
21
revised Deleting duplicate rows with condition(Using SQL and LINQ)
Formatted code
Dec
21
revised New Index on table cause table to be locked really often
added 56 characters in body
Dec
21
revised New Index on table cause table to be locked really often
added 56 characters in body
Dec
21
revised Why doesn't a delete increase unused space in a table?
added 16 characters in body
Dec
19
revised Conversion of a varchar data type to a datetime data type resulted in an out-of-range value
Minor typo fixes, added Books Online reference link