I investigate a new possibility in SQL Server 2014: creating and using memory-optimized table-valued parameters.

I investigate a deadlock issue with alias types and table-valued parameters, and the Connect items that have sprung up about this issue.

Tip : Script to Set the SQL Server Database Default Schema For All Users