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

Aug
9
revised Order by for 2 row result causes 800% performance hit
edited tags
Aug
8
revised Full Text Search Term Casing Affects Results
edited tags
Aug
8
revised Full Text Search Term Casing Affects Results
Formatting and comprehension
Aug
8
revised How to find when change tracking was enabled?
edited tags
Aug
8
revised Trouble quering a join in oracle sql
Improved code formatting (Ctrl+K)
Aug
7
revised UPDATE query with JOIN taking forever
typo, reduced snark level
Aug
7
revised UPDATE query with JOIN taking forever
deleted 150 characters in body; edited tags
Aug
5
revised problem faced while starting up a database in oracle
Formatting (CTRL-K for code blocks) minor edits for grammar
Aug
4
revised Side effects of using updlock lock hint?
deleted 210 characters in body
Aug
4
revised Side effects of using updlock lock hint?
Corrected a rather crucial word
Aug
3
revised Why is this query not using my nonclustered index, and how can I make it?
added 156 characters in body
Aug
2
revised MongoDB read performance
Incorporated question updates entered in comments (please edit instead)
Aug
1
revised Adding a sequence number to existing rows
deleted 71 characters in body; edited tags; edited title
Aug
1
revised Adding a sequence number to existing rows
added 1068 characters in body
Jul
31
revised Execute T-SQL Only If AlwaysOn Database Is Primary
Improved title, formatting, and tags
Jul
31
revised Connect to Postgresql 9.2 from Eclipse Data Tools Platform
Formatting
Jul
31
revised Removing a string prefix
deleted 24 characters in body; edited tags; edited title
Jul
31
revised Create failed for Index 'ClusteredColumnStoreIndex'. Timeout expired
edited tags
Jul
31
revised Query Plan Different When Using Compiled Values
Improved tags and spelling
Jul
31
revised Does READ UNCOMMITTED have the same effect as AUTOCOMMIT=1?
deleted 30 characters in body; edited tags