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

1d
revised Variable numbers of parameters in a SqlClr UDF or Stored Proc
added 64 characters in body
2d
revised Shared locks taken under Read Committed Snapshot Isolation (RCSI)
added 28 characters in body
2d
revised Shared locks taken under Read Committed Snapshot Isolation (RCSI)
deleted 261 characters in body; edited tags; edited title
2d
revised DISTINCT not using an index
Improved title, tags, minor edits for readability
2d
revised Avoiding entitized characters when using FOR XML PATH for string concatenation
Improved title, removed horizontal scroll bar from code window, fixed tags
2d
revised Avoiding entitized characters when using FOR XML PATH for string concatenation
Improved formatting, added TYPE directive, and BOL link
Apr
16
revised Order of maintenance plan tasks
deleted 1 characters in body; edited tags; edited title
Apr
15
revised Why do Indexed Views not permit non-unique clustered indexes?
Added paper reference
Apr
15
revised Formatting a float value
Improved title, readability, and tags
Apr
14
revised Inserting Serbian Latin and Cyrillic characters
Improved title, formatting, readability, tags
Apr
14
revised Display rows with no NULLs
Improved title and formatting
Apr
14
revised Listing indexes and constraints
Improved title, general readability, and formatting
Apr
14
revised Space not reclaimed after dropping MyISAM table
Improved title and formatting
Apr
14
revised MySQL behaviour on connection failure
Improved title, tags, grammar and readability, removed thanks
Apr
14
revised Why write ahead logs in PostgreSQL are generated every second
Improved title, grammar, and tags. Removed sign-off text.
Apr
14
revised Running query progress indication
Improved title, formatting, tags
Apr
14
revised Full text index search returns an unexpected result
Removed tag in title, general edits for English and formatting, remove code horizontal scroll bar
Apr
13
revised Variable numbers of parameters in a SqlClr UDF or Stored Proc
Removed code section horizontal scroll bars; fixed link markdown
Apr
11
revised Making a recursive CTE like query, but for many records
Renamed a column to be more realistic
Apr
11
revised Getting Visual Studio to deploy a UDF to Return NVARCHAR(MAX)
Added T-SQL script