SQL Server Performance Forum – Threads Archive
Index Clustering on 2005
What is the diferences in clustering indexes on 2005 between standard and enterprise? We are trying to figure out if we need the enterprise versionI think the ability to do table and index partitioning is only a feature of Enterprise. So if you have tables big enough that you need partitioning, that would be a factor.
Online build/rebuilds is also only available in Enterprise IIRC.
See ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/81f3e917-884a-4cc8-aca2-0a5fea89f355.htm in BOL for feature availability.
I’ve moved to relevant forum-
Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided “AS IS†with no warranties for accuracy.
quote:Originally posted by ron44141
What is the diferences in clustering indexes on 2005 between standard and enterprise? We are trying to figure out if we need the enterprise version
quote:Originally posted by ron44141
What is the diferences in clustering indexes on 2005 between standard and enterprise? We are trying to figure out if we need the enterprise version
In 2000 you had to have the Enterprise version to do index clustering. We need to need to know if this is still true. This is for a Data warehouse but could help a couple of our other databases too. The problem is, the price difference for Enterprise over Standard version. [:0]
]]>