Changing Database compatibility level will be required when you upgrade your database from one version to another and you want to use the latest feature for sql version. For details on compatibility check this earlier post. For example lets say when you upgrade a database from sql server 2012 to 2014 the compatibility level
To know what is compatibility Level check this post link. You can view the compatibility of SQL Server Database in two ways. From SSMS. Open SSMS -> Right click on Database -> Click properties -> Click on Options tab. 2. By running below SQL you can get the compatibility level
SQL Server Compatibility level will be used to decide how SQL will use it features. By setting compatibility level will make sure that SQL will follow that particular compatibility level version. It is a database property and will only affects the features for that particular database. For example with SQL 2014 or higher the new
In SQL server to check transaction log file size you can simply run this dbcc sqlperf(“logspace”) . This query will provide you the transaction log usage statistics for all the databases. The other way round is to run this DMV query which will provide you the usage for the selected database. Note,this will provide you
Starting from SQL server 2016 we have new String split function which will help to split a string in rows. With earlier version of sql server a developer would have to create his own custom scripts to achieve this task. Syntax : STRING_SPLIT( ‘string’,’separator’). Split string will divide the input string using a separator into
