nchar and nvarchar remain unchanged and store UTF-16 only. approx_count_distinct sys.dm_db_page_info returns about a page's header and can be used together with sys.dm_exec_requests and sys.sysprocesses to examine performance issues caused by pages. 15.0.2000.5.