15,576 reputation
44693
bio website sqlblog.com/blogs/paul_white/…
location New Zealand
age 44
visits member for 3 years, 1 months
seen 4 hours ago

Apr
19
reviewed Reviewed Postgresql JDBC Table Valued Parameters
Apr
19
reviewed Reviewed Mysql join two tables and limit by first input?
Apr
19
reviewed Reviewed Installing scott schema for oracle 11g express
Apr
19
reviewed Leave Closed Mirroring error #1418
Apr
19
revised Variable numbers of parameters in a SqlClr UDF or Stored Proc
added 64 characters in body
Apr
18
reviewed No Action Needed How to create multiple graphs with TitanDB (+Cassandra) in the same machine?
Apr
18
revised Shared locks taken under Read Committed Snapshot Isolation (RCSI)
added 28 characters in body
Apr
18
answered In SQL Server, should I force a LOOP JOIN in the following case?
Apr
18
reviewed Approve suggested edit on MySQL login after install
Apr
18
reviewed Leave Closed SQL Server Permission
Apr
18
awarded  Revival
Apr
18
reviewed Approve suggested edit on DISTINCT not using an index
Apr
18
answered Shared locks taken under Read Committed Snapshot Isolation (RCSI)
Apr
18
revised Shared locks taken under Read Committed Snapshot Isolation (RCSI)
deleted 261 characters in body; edited tags; edited title
Apr
18
revised DISTINCT not using an index
Improved title, tags, minor edits for readability
Apr
18
reviewed Leave Open Avoiding entitized characters when using FOR XML PATH for string concatenation
Apr
18
revised Avoiding entitized characters when using FOR XML PATH for string concatenation
Improved title, removed horizontal scroll bar from code window, fixed tags
Apr
18
revised Avoiding entitized characters when using FOR XML PATH for string concatenation
Improved formatting, added TYPE directive, and BOL link
Apr
17
reviewed No Action Needed Error checking with sp_send_dbmail
Apr
17
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.