Introduction

SQL Server 2014 has many new internal tables, views, Stored Procedures and functions or you can say SQL Server 2014 has many new Dynamic Management Views and Functions (DMVs), here's a few of the new instrumentation tables and views.

NEW INTERNAL TABLES

There are the following internal tables in the SQL Server 2014. You can see those tables by executing the query given below.

select * from sys.internal_tables

NEW VIEWS

There are the following views in SQL Server 2014. You can see the views by executing the query given below.

select * from sys.system_views

NEW FUNCTIONS

There are the following new functions in SQL Server 2014 and you can see those functions by executing the query given below.

SELECT * FROM sys.all_objects where type in ('FN','AF','FS','FT','IF','TF') order by name

Here are the types:

AF = Aggregate function (CLR)
C = CHECK constraint
D = DEFAULT (constraint or stand-alone)
F = FOREIGN KEY constraint
PK = PRIMARY KEY constraint
P = SQL Stored Procedure
PC = Assembly (CLR) Stored Procedure
FN = SQL scalar-function
FS = Assembly (CLR) scalar function
FT = Assembly (CLR) table-valued function
R = Rule (old-style, stand-alone)
RF = Replication filter procedure
SN = Synonym
SQ = Service queue
TA = Assembly (CLR) trigger
TR = SQL trigger
IF = SQL inlined table-valued function
TF = SQL table-valued function
U = Table (user-defined)
UQ = UNIQUE constraint
V = View
X = Extended Stored Procedure
IT = Internal table


NEW FUNCTIONS IN USER DATABASES/MSDB

There are the following new functions in user databases in SQL Server 2014:

NEW STORED PROCEDURES IN MASTER

There are the following new Stored Procedure in the master database. You get the list of Stored Procedure by executing "sp_help" in it.

NEW FIELDS IN EXISTING VIEWS

There are the following new fields in existing views in SQL Server 2014.

NEW FIELDS IN EXISTING FUNCTIONS

There are the following new fields in existing functions in SQL Server 2014.

Refer to: http://www.brentozar.com/