In this article I will briefly describe the difference between different version of SQL Server that should help you decide which one you need.
Please note Edition is sometimes mixed up with Version and I will discuss editions in a separate article.
What is Version
Let's start with the basics. What is Version when we refer to SQL Server? When SQL Server was developed it was Version 1 so everyone could use that but than behind the scenes new features were added and to make it easier for people to understand the changes, new features were released part of SQL Server Version 2.
SQL Server was essentially re-written in many aspects and new version was released but instead calling it Version 9.0 it was called SQL Server 2005. New features were added to SQL Server 2008 (Version 10) and than Microsoft wanted to add a little bit more but it was too little to make out of it a new version so Version 10.5 was released under the name of SQL Server 2008 R2 (R2 = Release 2).
After that we had SQL Server 2012 and at this point in time we have SQL Server 2014.
Which one should I use?
To get full access to this page
Become a member or Sign in
Membership is just $3.99/month