hi,

iam new to sql server. i have started reading an article in MSDN regarding the editions of sql server.the article says with the different headings as "server editions of sql server 2008r2" which includes (datacenter,standard and eneterprise) and where as other one "specialsed editions of sql server 2008r2" includes(sql server developer, sql server web,sql server workgroup,sql server express ,sql server express with tools etc..). 

here my question is ,what is the difference between these headings.could anyone explain to me? thank you...!!

here my question is ,what is the difference between these headings.could anyone explain to me? thank you...!!

The difference lies in features they support and provide. Not all editions of SQL Server provide every capability of database. Like express edition has limit of 10 G database, 1G memory 1 CPU. Standard edition cannot use Partition etc. To get list of features supported please read below BOL article

https://msdn.microsoft.com/en-us/library/cc645993%28v=sql.105%29.aspx

Different edition has different features :

Read the below link for details :

http://www.cloudvps.com/community/knowledge-base/sql2008r2-editions-compared/