Online Index Operations involving certain large data types are allowed in SQL Server 2012

Prior to SQL Server 2012, when you did online index operations (available in Enterprise Edition), if the index contained certain large data types (specifically varchar(max), nvarchar(max), varbinary(max)), then those online operations were not allowed on that index. That restriction does not exist

Read More - Register for Free Membership