Interesting question!

It seems to me that MARS will cause the same kind of confusion caused by asynchronous delegates... Good to know in advance.

I might argue that, if you're having update problems, you chose the wrong clustered index. Not that you shouldn't have had one at all.

Very good question.

Peter:

Structs can have methods, but no code access attributes (everything is public).

UDTs can be defined as either structs or classes. If you define one as a class, you must...

Who says there's nothing on the type but those properties?

How do you know there aren't private members that hold the geocode?

How do you know that the DistanceFrom() operator can't communicate...

Are + or - scalar operators _on the Address type_? Or are they scalar operators on OTHER types?

What is or is not a scalar operator depends on the type....

What's infeasible about having a class called Address in an OO language? I don't see any problem with that. You would have properties like StreetNumber, StreetPreDirectional, StreetPostDirectional, StreetName,...

I'm not sure what an "old fashioned" row is, or what "fake normalization" would look like. The fact is, we can't possibly know whether a given column called "bill"...

I agree, some of the auto-formatting is quite annoying (although you can turn it off if you want) -- it formats some code very differently than the way I want...

Chris,

Although VARBINARY(MAX) might be simpler in some ways, there are some arugments for UDTs. For instance, how would the DBMS constrain on the VARBINARY(MAX) to make sure that every...

Mike,

I think that conversion and encryption would be great for UDFs -- but I don't really see the point of having an 'encrypted' type, personally. What benefit would that...

The best example I've thought of so far is a rational number datatype. But I haven't yet figured out how to write it, given the way UDTs sort (based...

I don't think the answer to this question was wrong, but I didn't find this question to be especially useful; it didn't provide any kind of solution. Yes, every...

David --

Although SQL Server 2005 still schedules preemtively, UMS is gone (see: http://blogs.msdn.com/slavao/archive/2005/02/05/367816.aspx ). I believe SQLOS is supposed to handle context switching and other problems a lot more...

Don't get used to it