Tim Parker (9/24/2010)

---

The reason for the use of "WHERE 1 = 0" is so you do not hold locks on the SYSOBJECTS table in the database you're working with. ...

Would you mind sharing the settings you changed to resolve your...

jeff.lonn (9/24/2010)

---

Thanks all, this is now too costly of a solution, miffed at why they did this, besides the obvious, more income. Might have to look into moving some...

Robert Frasca (9/24/2010)

---

I'm confused as to why you don't think a field with the IDENTITY attribute is not a surrogate key or identifier. The only reason to use the...

Paul White NZ (9/24/2010)

---

If you trust me, you can just run the CREATE ASSEMBLY and CREATE FUNCTION statements from SSMS. There's no need to build it from the source...

sknox (9/24/2010)

---

So that gives us 2 identifier columns, remarkably similar to the two in this QotD -- and that's where you may have a point. But I'd caution here as...

Paul White NZ (9/24/2010)

---

TF 4199 enables all QO updates that might cause a different plan to be produced. There is a separate trace flag 41xx for all the individual...

Hugo Kornelis (9/23/2010)

---

I agree with UMG developer about the multiple identifier. I already had this option checked before deciding to check BOL first. I disagree with him about the missing...

Paul White NZ (9/2/2010)

---

Ok, let's go with that. Thanks for persisting 🙂

CREATE FUNCTION dbo.SplitString_Multi

(

...

Here are the results for the two test runs that I think you were looking for. This is from SQL Server 2008 R2 CU3, on my personal play server at...

I have to disagree with what you have as the correct answers for this question. The question states "According to Microsoft SQL Server Books online, what principles are not adhered...

Thanks for the article, it has helped me better understand how to create CLR functions.

The discussion is very good as well, so thanks again to everyone!

Thanks for the question, I appreciate the effort you have put forward in helping everyone to better understand transactions.

Nice question thanks!

Thanks for the question, it is good to review the basics of transactions!