sql server 2012 vs 2008 r2


  • are there any performance improvements in sql server 2012 over 2008 r2? I was hoping the database size would be increased but it's still stuck at 10GB. 
    Thursday, May 17, 2012 8:55 AM


All replies

  • Hi,

    You can use this to compare features available in express editions.  I think for a freebie, 10GB's pretty generous.

    Whether or not 2012 is more performant than 2008 without leveraging new features?  Maybe.  But things like columnstore indexes, T-SQL enhancements, showplan improvements, etc. could be used to improve upon existing application/database design.

    What's new in SQL Server 2012:


    Andrew Bainbridge
    SQL Server DBA

    Please click "Propose As Answer" if a post solves your problem, or "Vote As Helpful" if a post has been useful to you

    Thursday, May 17, 2012 12:55 PM
  • Hope this could be the solution, check this.

    Sunday, May 20, 2012 10:13 AM