python ruby-programming-language Smalltalk Vue.js Knockoutjs TypeScript JavaScript, OOPs JavaScript Angular 7, Interview Questions Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 4 Angular 2 AngularJs 1.x NodeJs Perl Programming R Programming RequireJs Rust Programming Backbonejs closure programming language go-programming-language kotlin-programming-language
SQL Server 2016 vs 2017 vs 2018

What's new in SQL Server 2018?

Added TSA-Grade Security -
1.     Added Table level security, restricts, user permissions on table data and table names
2.     Self-Destructing Transactions
3.     Indirect Checkpoint Performance Improvements
4.     Edible Result Sets
5.     Renaming SQL Server Agent to Cortana
6.     Full text search, now available for all supported Linux
7.     Online index build and rebuild support for non-clustered column-store indexes
8.     Added New SSMS
9.     Added Scented Error Messages
10.  Eventual Consistency
11.  Added Duraflame Transaction Log
12.  Access Storage Engine
13.  Added MAIM command
14.  Added Twitch Tntegration for Video Replay
15.  Azure Power Enterprise Server
16.  New DAX IN function
17.  Clustered Columnstore Indexes now support LOB columns (nvarchar(max), varchar(max), varbinary(max))
18.  Added New string functions CONCAT_WS, TRANSLATE and TRIM
19.  Full support for JSON functions
20.  Database Engine - New compatibility level 140
21.  Enhancements to In-Memory Tables & SPs
22.  Added sp_spaceused, sp_rename, CASE, TOP (N) WITH TIES
And So On..

Hi there! Welcome to my blog. My name is Anil Singh. I'm a author of this blog. For more detail about me, kindly refer to this link..
My Blogs - and
My Books - Interview Questions and Answers Books- Get Your Book in 15+ Digital Stores Worldwide..

You Might Also Like Powered by Blogger.
ASK Questions