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

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.
Apr
17
reviewed Leave Open Latitude and Longtitude Distance Calculation
Apr
17
reviewed No Action Needed ERWIN create and use database
Apr
17
reviewed No Action Needed Intermittent RESOURCE_SEMAPHORE_QUERY_COMPILE Wait Stats
Apr
16
reviewed Close SQL Server 2005 database log size increasing drastically?
Apr
16
reviewed Leave Open Index is not used with same Query on two Servers
Apr
16
reviewed Looks Good SQL Agent still attempting replication for deleted publication
Apr
16
reviewed Reviewed Order of maintenance plan tasks
Apr
16
revised Order of maintenance plan tasks
deleted 1 characters in body; edited tags; edited title
Apr
16
reviewed Reopen PostgreSQL DB size increasing after restoring the same database backup