locked
Difference between SQL server 2008 Sp2 standard edition and 2008 R2 sp1 standard edition RRS feed

  • Question

  • Hi All,

    If there is a big differance between  between SQL server 2008 Sp2 standard edition and 2008 R2 sp1 standard edition. please sned me wt kind of changes have between them. because my system can upgrade only to the 2008 R2 sp1.

    Thanks,

    robb

    • Changed type Olaf HelperMVP Thursday, September 12, 2013 10:45 AM More a question rather then a discussion
    Thursday, September 12, 2013 10:32 AM

Answers

All replies

  • Hi All,

    If there is a big differance between  between SQL server 2008 Sp2 standard edition and 2008 R2 sp1 standard edition. please sned me wt kind of changes have between them. because my system can upgrade only to the 2008 R2 sp1.

    Thanks,

    robb

    Hello,

    read below links they will be helpful

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/88db3acf-448b-402b-a11b-622a6d177aff/difference-between-sql-server-2008-sql-server-2008-r2

    and

    http://stackoverflow.com/questions/3419287/differences-between-sql-server-2008-and-sql-server-2008-r2-from-a-developers-po


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    • Proposed as answer by Sofiya Li Friday, September 13, 2013 8:41 AM
    • Marked as answer by Sofiya Li Wednesday, September 18, 2013 9:43 AM
    Thursday, September 12, 2013 10:43 AM
  • Hello,

    See also What's New (SQL Server 2008 R2) for a detailed list about new introduced features in R2


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Thursday, September 12, 2013 10:47 AM
  • R2 was basically a "BI release". The biggest improvements were in Reporting Services - and there they are huge(!) If you need SSRS, go for R2

    In the engine we got Unicode compression and compressed backups became available for standard edition (I believe in >= SP2 though)

    For Tracing purposes, Extended Events have been enhanced a lot, Security-wise we got Extended Protection and that's about it for the engine..


    Andreas Wolter | Microsoft Certified Master SQL Server
    Blog: www.insidesql.org/blogs/andreaswolter
    Web: www.andreas-wolter.com

    Thursday, September 12, 2013 12:14 PM
  • as far as I heard, sql server 2008 had lot of Bugs in it hence R2 released  for sql server 2008.

    Since you are saying about the sql server 2008 sp2 & sql server 2008R2 sp1

    see here-

    SQL Server 2008 R2 Standard Edition

    Designed for small and medium businesses, the Standard edition supports up to 4 CPUs and 2TB of RAM, with unlimited database size. It includes support for all BI subsystems including Analysis Services, Integration Services, and Reporting Services, but lacks many of the enterprise-oriented features from the Enterprise edition. It will be priced at $7,499 per processor or $1,849 per server with five CALs.

    with reference
    http://sqlmag.com/sql-server-2008/sql-server-2008-r2-editions

    Additiona info-
    http://www.microsoft.com/en-in/sqlserver/product-info/compare.aspx


    Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

    • Proposed as answer by Sofiya Li Friday, September 13, 2013 8:41 AM
    Thursday, September 12, 2013 12:31 PM
  • Hi All,

    Thanks a lot for your comments, actually i want to upgrade my DBs to next service pack. but still i can't fined the suitable upgrade option. my quality center release support only R2 sp1.

    Please share the best upgrade option i need to follow.

    from 2008 std  SP2 to 2008 std SP3 or

    from 2008 std SP2 to 2008 R2 SP1

    Thursday, September 12, 2013 5:09 PM