I appreciate your contributions and insights, Ken. Best of luck, get well quickly

Hi Kathi, the link at the bottom of your article to Tim's blog post appears to be broken.

Agree with Eric, nice tutorial on Git.

Off topic, but your commentary brought back memories of working on a short contract at the (now decommissioned and demolished) Trojan nuclear power plant on the Columbia River in Oregon....

WRT compiling this procedure on production servers, would it be possible to run this as a temp sproc on that system?

IF OBJECT_ID (N'tempdb..#usp_String_Search', N'P') IS NULL

BEGIN

EXECUTE ('CREATE PROCEDURE...

I once worked briefly at the Trojan nuclear power plant in Oregon; no issues with power there. The office was in the shadow if the cooling tower. That...

Not a new idea.

http://www.glassdoor.com/

Enjoyed the article right up to the point where it linked to the SQL Server documentation on the feature, and felt compelled to look. Don't bother. Looks like...

Nice article. Just wanted to point out that you can generate an XDL file from the Profile trace window just by right-clicking the Deadlock Graph event. Choose the...

I could not agree more with rwatson's reply above. In additional, I'll add that, in my case, I've spent time understanding it with my DBAs. But there is an...

Paul asks, @steve-2 McNamee: Are you saying that the technique used in the article is faster than FOR XML PATH for fewer than 500 elements? Not nit-picking; I...

Nice article. A minor nit-pick. You need to initialize the @col variable to an empty string befory running the MAV query. Otherwise, your result will be NULL.

I've also used...

It does not work like that on my machine. When I copied your string, and clicked on a word, I got only that word.

One simple thing I'd like to do is just print a list of the package variables, and their properties. Is there an easy way to do that?

VariableName...

Looks like this is a data typing issue. When I use the Expression (DT_WSTR, 4) @[User::RowCnt] to set the Argument property of the Execute Process Task, the value...