for sure !  I've used UDTs for years - example:  when having a db using typical autoincrement primary keys; that means any FK reference is of data type "int".  SO...

one freaky thing though .. this issue is posted on "feedback.AZURE.com ..." - as if SQL Server was a sub-entity of the Azure cloud world (I sure as sh*t hope...

Nice summary. Probably the biggest disappointment with TVPs is how promising they are in concept but how limiting they are in practice. Its unfortunate that one needs to define...

Grant you seem more stressed than Gail; the point of discussion was Gail earlier stmt:

"Just watch the performance implications. A single statement tvf is usually fine, the multi-statement ones temd...

Just watch the performance implications. A single statement tvf is usually fine, the multi-statement ones temd not to perform well if they are returning lots of rows and are part...

thanks for the boot in the right direction ! Was such an obtuse topic (I thought) that it never even occurred to me to search in BOL. For anyone watching...

regarding comment:

"view vs stored proc....you still need to wrap the view up in a stored proc in order use dynamic selection criteria."

wrong - use a table-valued function. Much tidier and...

hey Ryan I know what u mean - stepping into dba shoes seems often like moving into the Dark Arts or something - tons of sage knowledge from all directions...

why not add in diagrams and foreign key constraints? surely there's a perf penalty to consider when every fk is constantly yet needlessly checked by the dbms when the...