# SQL Maintenance & Miscellaneous Questions

**URL:** <https://www.epiusers.help/t/sql-maintenance-miscellaneous-questions/37860>\
**Category:** Epicor ERP 10\
**Created:** [March 30, 2017, 5:44pm UTC](https://www.epiusers.help/t/sql-maintenance-miscellaneous-questions/37860 "2017-03-30T17:44:46Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Hally](https://www.epiusers.help/user_avatar/www.epiusers.help/hally/32/1263_2.png) [@Hally](https://www.epiusers.help/u/Hally)\
**Post date:** [March 31, 2017, 3:20am UTC](https://www.epiusers.help/t/sql-maintenance-miscellaneous-questions/37860/2 "2017-03-31T03:20:51Z")

</div>

Cost is a big factor. Std to Enterprise is a bit scary.

Here is a link to all the differences between the editions of SQL 2012 [Features Supported by the Editions of SQL Server 2012 | Microsoft Learn](https://msdn.microsoft.com/en-us/library/cc645993(v=sql.110).aspx)

2016 does have a lot of improvements including and lot of Enterprise features have be moved to standard with SP1. of course I would not recommend upgrading to a version of SQL that did not meet the certification of your vendor.

Here is another post you might find useful:

> **[SQL Index and other Maintenance Plans](https://www.epiusers.help/t/sql-index-and-other-maintenance-plans/37441)**
>
> My Server & DB guys are looking to optimize our SQL maintenance plans for when we go live with 10.1 Epicor. So I thought I’d pose the question here as I’m no SQL expert on setting reindex plans and setting fill-rates. I’d be happy to pass on...

Good luck with your SQL adventures. Sounds a bit like me, but I started with Platinum SQL 4.2 and SQL Server 6.5, quite a while back.

---

_[View the full topic](https://www.epiusers.help/t/sql-maintenance-miscellaneous-questions/37860)._
