New In-Memory OLTP improvements in CTP3.1 include:
- Unique indexes in memory-optimized tables, to complement the support for unique constraints that was released in CTP3
- LOB data types varchar(max), nvarchar(max), and varbinary(max) in memory-optimized tables and natively compiled modules
- Indexes with NULLable key columns in memory-optimized tables
Syntax inputdate AT TIME ZONE timezone.
- Inputdate: An expression that can be resolved to a smalldatetime, datetime, datetime2, or datetimeoffset value.
- Timezone: Name of the destination time zone in standard format as enumerated by Windows. Available time zones can be found by querying sys.time_zone_info.
SQL Server Analysis Services (SSAS) updates allow upgrading your existing models to 1200 compatibility level and a JSON editor for SSDT;