Compatibility Level

https://msdn.microsoft.com/en-us/library/bb510680.aspx?f=255&MSPPError=-2147217396 Compatibility-level setting of 120 SQL Server 2014 SQL Server 2014 includes substantial improvements to the component that creates and optimized query plans. This new query optimizer feature is dependent upon use of the database compatibility level 120. New database applications should be developed using database compatibility level 120 to take advantage of these improvements. […]