locked
MS SQL 2012 or MS SQL 2014? RRS feed

  • Question

  • I are currently running MS SQL Express 2012 but the database is running out of space frequently. I am thinking of installing MS SQL Standard Edition but would like you expertise on the avenue to take.

    Would it be best to install MS SQL 2012 or MS SQL 2014?
    Thursday, February 19, 2015 7:12 PM

Answers

All replies

  • Check out this similar question on the forums that compares 2012 to 2014.

    As far as database disk space used it does not matter which edition you install as this is not the root of the problem. This might be due to growth of data or to transactions taking up room in the log, you will have to be more specific about the problem so that the suggestions on how to solve it will be relevant to your situation.


    -Igor

    Thursday, February 19, 2015 7:29 PM
  • Hello,

    SQL Server 2014 will have more years of support than SQL Server 2012. SQL Server 2014 Standard Edition now supports 128 GB of RAM, while SQL Server 2012 only supports 64 GB of RAM.

    https://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx



    Hope this helps.



    Regards,



    Alberto Morillo
    SQLCoffee.com

    • Marked as answer by KingMoffy Thursday, February 19, 2015 8:37 PM
    Thursday, February 19, 2015 7:47 PM
  • --Igor

    Thank you for your response. I am not experiencing a hard disk space issue. The post was related to the limitation of SQL Express maximum database capacity. The question was directed to which edition of server MSSQL Server implementation would be recommended.

    Thursday, February 19, 2015 8:47 PM
  • Thanks Alberto Morillo for your response. This is more along the line I was thinking.
    Thursday, February 19, 2015 9:04 PM