Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is the main differences between sql server 2008 and sql server 2012?

SQL SQL Server 2000 2008
user-image
Question added by Mahmoud AbdelBadei , IT Department Official , Shoaa Alkhobar
Date Posted: 2014/05/07
Upvote (0) Views (26) Followers (0) Answers (5) Report Question
Write an Answer
Register now or log in to answer.
Samer Haterm
by Samer Haterm , Development Analyst , SyrianSoft, Damuscus.Ne

There is money put I've seen the most value New Analytic Functions like FIRST_VALUE LAST_VALUE

add ORDER BY in the OVER for aggregate functios Like SUM AVG

Deleted user

CONCATE,FORMAT and PARSE where added in sqlserver2012 which were not present in sqlserver2008.

Sandhya Binoy
by Sandhya Binoy , Software Professional , Karrox technologies

1)Sequence is not avaiable in SQL server2008.Sequence is included in SQL Server2012.

Sequence is a user defined object that generates sequence of the number.

2)The maximum number of concurrent connections to SQL Server2008 is32767.

SQL Server2012 has unlimited number of concurrent connections.

3)SQL Server2008 uses27bit precision for calculations.

Sql server2012 uses48 bit precision for calculations.

4)TRY_CONVERT() and FORMAT() functions are included in SQL server2012

But not available in SQL server2008.

 

 

karim kamel
by karim kamel , Developer Support Engineer , Microsoft

SQL Server2008

Web Development and Business Intelligence Enhanced with business intelligence features. Excel PowerPivot by adding more drill and KPI through.

 

Sql Server2012

 

In Addition with SQL server2008, Web Development and Business Intelligence Enhanced with business intelligence features and Excel PowerPivot by adding more drill and KPI’s.

 

 

Write Your Answer
More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.

Get Help