Very recently one of my client argued on the effect ALTER TABLE ADD or ALTER TABLE DROP column has on an existing table having millions of records. AFAIK, the add column and drop column do not have a significant impact as the changes made are matadata changes. Still, to prove the point , here is […]

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. […]

  Check database ownership of Databases on a SQL Instance