18,446 reputation
453103
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 3 years, 4 months
seen 4 hours ago

Aug
3
revised Moving a database to a new server
deleted 177 characters in body; edited title
Aug
3
revised What is a standard or conventional name for a column representing display order?
edited body; edited title
Aug
3
revised Fill factor based on index ranges
Formatting, more concise title
Aug
2
revised How to select from a table without including repeated column values?
added 353 characters in body
Aug
2
revised How to select from a table without including repeated column values?
Added optimal index, execution plan for larger number of rows
Jul
31
revised How to select from a table without including repeated column values?
Added execution plan
Jul
31
revised How to select from a table without including repeated column values?
Added execution plan
Jul
31
revised Distinct rows from a join
Formatting, title, image and tags
Jul
30
revised Apply profiler template to saved log
Improved formatting, title, and tags
Jul
30
revised How does SQL Server know predicates are correlated?
edited tags; edited title
Jul
30
revised Need to understand parallel query execution error
edited tags
Jul
29
revised After update triggers that deal with multi-row updates
edited tags
Jul
29
revised How to get output from trigger on linked server
edited tags
Jul
29
revised UPDATE statment with and without SELECT keyword
edited tags
Jul
29
revised How to insert in table from remote stored procedure without creating a distributed transaction?
edited tags
Jul
29
revised How can I drop a stored procedure whose name is in a variable?
edited tags
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