Columnstore indexes and batch-query execution mode are deeply integrated in SQL Server 2012, and they work in conjunction with many of the Database Engine features found in SQL Server 2012. For example, database administrators can implement a columnstore index on a table and still successfully use AlwaysOn Availability Groups (AG), AlwaysOn failover cluster instances (FCI), database mirroring, log shipping, and SQL Server Management Studio administration tools. Here are the common business data types supported by columnstore indexes:
• char and varchar
• All Integer types (int, bigint, smallint, and tinyint)
• real and float
• money and small money
• All date, time, and DateTime types, with one exception (datetimeoffset with precision greater than 2)
• Decimal and numeric with precision less than or equal to 18 (that is, with less than or exactly 18 digits)
• Only one columnstore index can be created per table.