New feature in sql server 2012

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.