Anil Singh | Code-sample.com

SQL Server 2017 Database Engine - 1.     New string functions are CONCAT_WS , TRANSLATE , and TRIM , and WITHIN GROUP 2.       CLR assemblies 3.       In-memory enhancements 4.       Resumable online index rebuild 5.     IDENTITY_CACHE 6.       ADMINISTER DATABASE BULK OPERATIONS is now visible in sys.fn_builtin_permissions 7.       Automatic database tuning 8.       Graph database capabilities 9.       A sp_configure option called clr strict security is enabled by default to enhance the security of CLR assemblies. 10.   Setup now allows specifying initial tempdb file size up to 256 GB per file 11.   modified_extent_page_count 12.   SELECT INTO T-SQL syntax now supports loading a table into a FileGroup other than the user's default by us...