15,365 reputation
44592
bio website sqlblog.com/blogs/paul_white/…
location New Zealand
age 44
visits member for 3 years, 1 month
seen 17 mins ago

2h
reviewed Approve suggested edit on MySQL login after install
4h
reviewed Leave Closed SQL Server Permission
5h
awarded  Revival
9h
reviewed Approve suggested edit on DISTINCT not using an index
12h
answered Shared locks taken under Read Committed Snapshot Isolation (RCSI)
12h
revised Shared locks taken under Read Committed Snapshot Isolation (RCSI)
deleted 261 characters in body; edited tags; edited title
13h
revised DISTINCT not using an index
Improved title, tags, minor edits for readability
15h
reviewed Leave Open Avoiding entitized characters when using FOR XML PATH for string concatenation
15h
revised Avoiding entitized characters when using FOR XML PATH for string concatenation
Improved title, removed horizontal scroll bar from code window, fixed tags
15h
revised Avoiding entitized characters when using FOR XML PATH for string concatenation
Improved formatting, added TYPE directive, and BOL link
21h
reviewed No Action Needed Error checking with sp_send_dbmail
1d
comment Index is not used with same Query on two Servers
Consider deleting this question?
1d
comment Creating Clustered Index uses all my tempdb space. Why?
Yes it has to sort somewhere, but for SORT_IN_TEMPDB = OFF as stated in the question, neither the sort runs nor the mapping index use tempdb. The point about uniquifiers for non-unique indexes is valid, but doesn't really answer the question either.
1d
reviewed Leave Open Latitude and Longtitude Distance Calculation
1d
reviewed No Action Needed ERWIN create and use database
1d
reviewed No Action Needed Intermittent RESOURCE_SEMAPHORE_QUERY_COMPILE Wait Stats
1d
reviewed Close SQL Server 2005 database log size increasing drastically?
1d
reviewed Leave Open Index is not used with same Query on two Servers
1d
reviewed Looks Good SQL Agent still attempting replication for deleted publication
1d
comment SQL Agent still attempting replication for deleted publication
It's ok to mark your own answer to your own question as "the answer".