当前位置: 代码迷 >> Sql Server >> 关于SQL2008标准版的一些有关问题~
  详细解决方案

关于SQL2008标准版的一些有关问题~

热度:65   发布时间:2016-04-27 17:19:20.0
关于SQL2008标准版的一些问题~~
请问各位高手,SQL2008标准版有没有分区函数这个功能的...
如果没有的话,那么有没有类似于分区函数功能的其它功能结构???..

------解决方案--------------------
SUPPORTED EDITIONS:
It must be noted that the partitioning feature is only supported on the Enterprise Edition of SQL Server 2008. So, if you backup your database, in which you have used this feature, and try to restore it on a lower edition, this will not be possible.

To check if this feature is being used on your SQL Server instance, you can use sys.dm_db_persisted_sku_features dynamic management view introduced in 2008.