Lots of New feature has been introduced with sql server 20012, it is the latest version from Microsoft after sql server 2008 r2.
Below are some features ….
1)Sequence : this feature is already with oracle and post gre sql, but microsoft has introduced with 2012 version, under programmability , sequence can be found, it is basically uses for increment in table.
2)Column Stored Index :It is great feature for performance for sql server 2012 , in data pages there may be different column can be stored , suppose there are two types of pages are like page 1 and page 2 , page 1 contains column1,column2 etc, page2 can contains column1,column2 etc, but for fetching only column1 that time sql server will find page1 and page 2 , but in sql server 2012 there is new feature for column stored index, if for column1 , all these can be stored in page 1, for this facility for selecting column1 , only single page is required to find.It is usefull for non clustered index.
3)Pagination: In mysql there is very good feature called limit , if i want to select 5 records from table , i have to use only LIMIT 0,4 .
But in sql server , we have to do by only Row_number(),RANK(),TOP with order by etc.
But in sql server there is really good feature came called pagination.
The key word is OFFSET AND FETCH , now if i wanted to get 4 records from user table , sql will be like that
select * from tbluser order by id
OFFSET 4 rows only
For selecting next 5 we have to use sql like
fetch next 5 rows
4)Error handling: try catch block previously was introduced by sql server , but in c# for full object oriented language , THROW keyword was there , but in sql server 2012 throw key word has been introduced.
Leave a Reply