19,705 reputation
457109
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 3 years, 6 months
seen 1 hour ago

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
Jul
30
revised Cube processing either takes too long or fails
Sentence did not make sense (corrected spelling in the original suggested edit)
Jul
30
revised Index seek much slower with OR condition compared with separate SELECTs
Improved title and tags
Jul
30
revised Index seek much slower with OR condition compared with separate SELECTs
Incorporated my answer
Jul
28
revised Incorrect result when you execute a query that uses WITH RECOMPILE option in SQL Server 2012
Removed duplication in title, updated tags
Jul
25
revised Is support for Parallel Scalar UDF a reasonable feature request?
added 29 characters in body
Jul
25
revised View with left joins are very slow
deleted 50 characters in body; edited tags; edited title
Jul
25
revised Whether Logfile Shrinking is good or bad one for Performance in SQL?
deleted 19 characters in body
Jul
24
revised How do I place leading zeros for numbers less than 10 without affecting those 10+?
edited tags
Jul
24
revised Matching two rows in a single table if two specific keys have different values
added 53 characters in body
Jul
24
revised Merge/combine two queries with different dates
added 228 characters in body; edited tags; edited title
Jul
24
revised Query to join three tables
formatting, title, tags
Jul
24
revised Query to join three tables
formatted code
Jul
23
revised SQL Server mirrored database is stuck in recovery mode
Formatting
Jul
22
revised Why are U locks required when using Read Committed Snapshot Isolation
added 269 characters in body
Jul
22
revised Why are U locks required when using Read Committed Snapshot Isolation
Minor formatting, removed tag in title
Jul
22
revised Why are U locks required when using Read Committed Snapshot Isolation
added 363 characters in body
Jul
22
revised Why are U locks required when using Read Committed Snapshot Isolation
added 363 characters in body