1. Column store index
2. Pagination. - get results into part.
3. Contained database - when user will login at that time it will check databases access for logging user.
4. Sequence objects- it similar to Oracle sequence object. It used for creating identity.
5. Error handling- it introduced THROW keyword. More useful to raiserror option.
6. User defined roles- now user can can create new new server level role.
7. Windows Server Core support- sql user can be performed will windows level activities from sql server 2012.
8. Tabular model- (SSAS)
9. Power view
10. DQS data quality service- it's used for change and purring data.
2. Pagination. - get results into part.
3. Contained database - when user will login at that time it will check databases access for logging user.
4. Sequence objects- it similar to Oracle sequence object. It used for creating identity.
5. Error handling- it introduced THROW keyword. More useful to raiserror option.
6. User defined roles- now user can can create new new server level role.
7. Windows Server Core support- sql user can be performed will windows level activities from sql server 2012.
8. Tabular model- (SSAS)
9. Power view
10. DQS data quality service- it's used for change and purring data.
No comments:
Post a Comment
Thank You !!!!