Reputation
28,786
Next tag badge:
186/100 score
18/20 answers
Badges
10 134 227
Newest
 Enlightened
Impact
~893k people reached

Apr
26
revised How to rewrite a query with MAX in WHERE clause
Added summary
Apr
26
revised How to rewrite a query with MAX in WHERE clause
Incorporated useful information from comments
Apr
26
revised How to rewrite a query with MAX in WHERE clause
rolled back to a previous revision
Apr
26
revised How to rewrite a query with MAX in WHERE clause
Needs WITH TIES to preserve the original semantics using MAX
Apr
26
revised How can I remove 'Using temporary ' and speed up my query
rolled back to a previous revision
Apr
25
revised Sql service account password change for environment on Availability groups 2012
deleted 7 characters in body
Apr
25
revised Duplicates when checking for two different column values based on a key that is not unique in table
Formatting; tags
Apr
25
revised Duplicates when checking for two different column values based on a key that is not unique in table
Code formatting to avoid horizontal scrollbar; removed tagline
Apr
25
revised How to rewrite a query with MAX in WHERE clause
added 57 characters in body
Apr
25
revised Rebuilding the transaction log
Incorporated comment
Apr
25
revised Rebuilding the transaction log
Fixed broken link, general tidy up
Apr
25
revised Rebuilding the transaction log
Incorporated comments; general tidy up
Apr
25
revised Rebuilding the transaction log
deleted 635 characters in body; edited tags
Apr
25
revised Execution Plan is NOT using INDEX and uses Table Scan
Clarified reason for RID lookup
Apr
25
revised Is total_elapsed_time in DMV sys.dm_exec_requests completely inaccurate?
Formatting
Apr
25
revised How to return rows between two datetimes stored as date and time?
Formatting
Apr
25
revised Execution Plan is NOT using INDEX and uses Table Scan
Incorporated comment; added some detail
Apr
25
revised OrderBy int slow for large table join
Incorporated comments
Apr
25
revised Ternary relationship with history tracking
Incorporated comment; edited tags
Apr
25
revised How can I return top 10 rows from each state
edited tags