18,162 reputation
453102
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 3 years, 4 months
seen 46 mins ago

Jul
29
revised A Tool to Manage Tracking Query Performance Improvements
added 18 characters in body; edited tags; edited title
Jul
28
revised Updating a table efficiently using JOIN
Shortened title, in-lined a link
Jul
27
revised In Microsoft SQL Server 2008, syntax generates the error “The Parallel Data Warehouse (PDW) features are not enabled.”
deleted 2 characters in body
Jul
27
revised Workaround for Anti-Semi Join bug
Added WHERE clause reversal
Jul
27
revised Workaround for Anti-Semi Join bug
Too harsh!
Jul
27
revised Workaround for Anti-Semi Join bug
Tags, scrollbar, title
Jul
27
revised In Microsoft SQL Server 2008, syntax generates the error “The Parallel Data Warehouse (PDW) features are not enabled.”
Removed unnecessary opinion piece
Jul
26
revised Forwarded Records, effective way to fix them
Incorporated comment suggestions
Jul
25
revised Which Edition Of SQL Server Is On The Disc?
Various small improvements
Jul
25
revised LIKE uses index, CHARINDEX does not?
added 145 characters in body
Jul
24
revised LIKE uses index, CHARINDEX does not?
deleted 201 characters in body; edited title
Jul
23
revised Escaping T-SQL Keywords
added 10 characters in body; edited title
Jul
23
revised Do database engines update when the updated value is the same?
added 292 characters in body
Jul
15
revised Check existence with EXISTS outperform COUNT! … Not?
added 3228 characters in body
Jul
8
revised Optimize UNION query in MySQL
edit so I change my vote :)
Jul
8
revised When SQL Server uses Multi Page Allocations
added 1315 characters in body
Jul
8
revised When SQL Server uses Multi Page Allocations
Grammar, site style, and readability
Jul
8
revised When SQL Server uses Multi Page Allocations
added 193 characters in body
Jul
7
revised If there exist multiple similar Values than show Sum of a another column else Show simple Value
deleted 8 characters in body
Jul
4
revised -E startup option and SSDs
added 1160 characters in body