I found a [blog post|http://www.componentix.com/blog/5/improved-hibernate-dialect-for-microsoft-sql-server
] which says that the following type mappings should be used for SQL Server:

We should investigate and see if they should be used by default.