Why pick the first thing he said?  I chose the last thing!  He had pretty much the same conversation we're having and already made the distinction between testing...

A few pages back Jeff Moden wrote:

And, that's why I don't care for what people are calling "Unit Tests". It doesn't make sense to have two pieces of code...

Not really. Saying that I don't think you understand, is not an ad hominem attack. I also didn't mean it as an insult, just trying to figure out where you're...

[

New development and modifications should be tested over and over until they work...

Ah, ok. So the reason you may want to keep unit tests is if anything needs to change with your data model, you've already documented how things should work...

In my opinion unit testing in a relational database is basically fruitless.  The whole idea is the data model is schema bound.  So what are you testing but...

David

the non-SQL parts of our C# app are tested with a few unit tests and a lot of manual tests.

We plan to reverse the quantity (unit testing first...

In my opinion unit testing in a relational database is basically fruitless.  The whole idea is the data model is schema bound.  So what are you testing but only to...

Answered the question only so I could comment about Service Broken. Please don't correct it, it's appropriate as is.

Interesting! I have to admit, I didn't know the answer, but used the process of elimination and then chose the most shocking of the 2 answers left. Now I'm going...

Well, I fell trap to semantics. I held tight to the keyword "seen" and all that could truly be seen in what was provided was the one index. Oh well.

I think you have a typo in your first paragraph, last sentence. I think you meant resorting and not restoring.
That being said, I enjoyed the article. As someone whose...

Oh wow. Why have I never considered using APPLY for this purpose? You've just simplified my life. Thank you, sir!