You are right that they sometimes return positives on things that might not be intended as numbers...

I'll hop on the bandwagon and say I would love to see this article, Phil.

And you are quite correct. ...

jacroberts (11/25/2008)

---

Adam Machanic (11/25/2008)

---

If you have a daily report that is run in batch, with no user waiting at the end of a button for the result, it doesn't matter...

jacroberts (11/25/2008)

---

timothyawiseman (11/24/2008)[hr

>>The problem is that your example did not show a case where efficiency is not a concern.

>>But, in your example you say there is no need to worry...

jacroberts (11/24/2008)

---

timothyawiseman (11/24/2008)

---

I've worked on and improved the performance of a lot of different SQL systems and I know when...

I agree with Jeff that performance should always be a concern. After all, you may eventually need that report...

The article was well written, but it is worth noting that Jeff Moden described a more set based approach to creating the same thing in http://www.sqlservercentral.com/articles/TSQL/62867/

Lynn Pettis (11/24/2008)

---

Sorry, but the code I posted isn't quite right. If Col3 is null or Col2 and Col3 is null, you end up with a ',' at the...

This is definitely an interesting article, but, to echo some of the others, it does have the feel of an ad.

Moreover, it seems that this would buy you relatively little...

Heh. Robert and Mohit have a point. Instead of triggers views could be used to let a legacy application interact with and change the data in the way...

The one thing I can think of off hand, (and I have never done this in practice) where you would need an instead of trigger is for being able to...

The article was well written, but probably extremely basic for people who read this site.

One thing I will point out is that you may want to make backups of the...

That makes complete sense. Thanks.

Yes, and changes to the view definition do get propogated, but the indexes (even the clustered index) does not.

Ok, Jeff proved that the table is larger with an index than without, but why would that be true of a clustered index? Doesn't a clustered index primarily order...