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

10m
revised Variable numbers of parameters in a SqlClr UDF or Stored Proc
added 64 characters in body
21h
reviewed No Action Needed How to create multiple graphs with TitanDB (+Cassandra) in the same machine?
21h
revised Shared locks taken under Read Committed Snapshot Isolation (RCSI)
added 28 characters in body
21h
answered In SQL Server, should I force a LOOP JOIN in the following case?
1d
reviewed Approve suggested edit on MySQL login after install
1d
reviewed Leave Closed SQL Server Permission
1d
awarded  Revival
1d
reviewed Approve suggested edit on DISTINCT not using an index
1d
answered Shared locks taken under Read Committed Snapshot Isolation (RCSI)
1d
revised Shared locks taken under Read Committed Snapshot Isolation (RCSI)
deleted 261 characters in body; edited tags; edited title
1d
revised DISTINCT not using an index
Improved title, tags, minor edits for readability
1d
reviewed Leave Open Avoiding entitized characters when using FOR XML PATH for string concatenation
1d
revised Avoiding entitized characters when using FOR XML PATH for string concatenation
Improved title, removed horizontal scroll bar from code window, fixed tags
1d
revised Avoiding entitized characters when using FOR XML PATH for string concatenation
Improved formatting, added TYPE directive, and BOL link
2d
reviewed No Action Needed Error checking with sp_send_dbmail
2d
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.
2d
reviewed Leave Open Latitude and Longtitude Distance Calculation
2d
reviewed No Action Needed ERWIN create and use database
2d
reviewed No Action Needed Intermittent RESOURCE_SEMAPHORE_QUERY_COMPILE Wait Stats
Apr
16
reviewed Close SQL Server 2005 database log size increasing drastically?