Dynamic Management Views

SQL Server 2014 new DMV – Figure It Out Yourself

Hi Friends, In this post, I am demonstrating how you can figure out SQL Server 2014 new DMV, yourself! From SQL Server 2014 VM (or a physical box), add a Linked Server connection to a SQL Server 2012 VM (or a physical box) And execute the following script: SELECT a.NAME sql2014 ,b.NAME FROM sys.sysobjects a [...]


Go to Top