difference between SQL Server 2008 and SQL Server 2012

Mostly Interviewer are ask to, what is difference in SQL server 2008 and SQL server 2012.

What's new in SQL Server 2016? click for detail http://goo.gl/yZI7eR

In short, we can explain to differences in deeply.

In SQL Server 2012, uses 48 bit precision for spatial.
In SQL server 2012, has unlimited concurrent connections are available.
In SQL server 2012, by default supports 15,000 partitions in DB.
In SQL server 2012, available new string function CONCAT to strings.
In SQL server 2012, available new string function FORMAT to strings.
In SQL server 2012, available new conversion functions are PARSE ,TRY_CONVERT, and TRY_PARSE.

In more details visit
http://anildroisys.blogspot.in/2012/01/what-is-difference-between-sql-server.html

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..

My Tech Blog - https://www.code-sample.com/
My Books - Book 1 and Book 2

difference between SQL Server 2008 and SQL Server 2012

Reviewed by Unknown on 12:50 AM Rating: (5)