Excellent Article. Thank you for providing it. I will be passing this off to some of my friends soon.

A very interesting and thought provoking article. Thank you!

On actually making your application more resistant to locking, the careful use of the "with (nolock)" query hint can improve performance...

Fantastic article, thank you.

Related to your very first example, one should always think about scaling when writing code. Sometimes, especially when making prototypes, the deliberate plan is...

pete callaghan (2/2/2010)

---

It will challenge the religious dogma from all the jobsworths out there, but I would love to find just one REAL example of a security breach via xp_commandshell....

Pei Zhu-415513 (2/2/2010)

---

It is just a story "close one door/open another door". If you use sproc to wrap xp_cmdshell, you control what the sproc can do. Keep in mind the...

m.ciesiensky (1/6/2010)

---

Timothy,

when attempting to run sp_msforeachtable in each of the variations below, I get these errors. I have tried running from both the master and CBL databases, with all...

That makes a lot of sense. Thank you.

A well written and good article that presents an interesting approach. I am curious, why would you want to do this instead of (temporarily) taking the database off of...

Jeff Moden (12/23/2009)

---

I'm not picking on the author here... it's a general statement that I bring up to anyone who may be considering the use of CLRS... Don't use...

Jack Corbett (12/11/2009)

---

The reason I don't use the CLR is simple. I haven't had a task where I found it to be necessary. I don't work on big,...

Kurt W. Zimmerman (12/8/2009)

---

I had a stored procedure that performed "global search" that queried 3 tables which were rather large in size. I had gone ahead and tuned each...

Grant Fritchey (12/4/2009)

---

I don't entirely agree with #4 though. Certification just doesn't seem to be worth much and when you factor in the cheat guides, it becomes worth less. I'd...

This does seem to be a tough crowd in the thread today.

I think it was a well done article, and I agree with the basic outline. Thank you for...

atkinsd (11/30/2009)

---

Thanks for the article. I've used a number of these stored procedures before but a couple were new to me.

One interesting point that you may or may not...

Some extended procedures are documented and those are very likely to remain supported...