MSBI Tutor

Months: SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()) - 1, 0) -- First day of previous month SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), -1) -- Last Day of previous month SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0) -- First day of this month SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()) + 1, -1) -- Last day of this month SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()) + 1, 0) -- First day of next month SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()) + 2, -1) -- Last day of next month Quarters: SELECT DATEADD(QUARTER, DATEDIFF(QUARTER, 0, GETDATE()) -1, 0) -- First day of previous quarter SELECT DATEADD(QUARTER, DATEDIFF(QUARTER, 0, GETDATE()), -1) -- Last day of previous quarter SELECT DATEADD(QUARTER, DATEDIFF(QUARTER, 0, GETDATE()), 0) -- First day of this quarter SELECT DATEADD(QUARTER, DATEDIFF(QUARTER, 0, GETDATE()) + 1, -1) -- Last day of this quarter SELECT DATEADD(QUARTER, DATEDIFF(QUARTER, 0, GETDATE()) + 1, 0) -- First day of next q...

PERFORMANCE & SCALE o         In-Memory OLTP o         Enhanced In-Memory ColumnStore for DW o         Buffer Pool Extension to SSDs o         Enhanced Query Processing o         Resource Governor adds IO governance o         SysPrep at cluster level o         Predictable performance with tiering of compute, network, and storage with Windows Server 2012 R2 HIGH AVAILABILITY o         Enhanced AlwaysOn, with 8 secondaries and Replica Wizard o         Delayed Durability o         Clustered Shared Volume support, VHDX...

PERFORMANCE & SCALE o        In-Memory OLTP o        Enhanced In-Memory ColumnStore for DW o        Support for 640 logical proc. & 4 TB memory o        Support to 15,000 partitions o        Resource Governor IO governance o        Buffer Pool Extension to SSDs o        Query optimization enhancements o        SysPrep at cluster level o        Predictable performance with tiering of compute, network, and storage with Windows Server 2012 R2 HIGH AVAILABILITY o        SQL Server AlwaysOn o     ...

PERFORMANCE & SCALE o        In-Memory OLTP o        Enhanced In-Memory ColumnStore for DW o        Support for 640 logical proc. & 4 TB memory o        Support to 15,000 partitions o        Resource Governor IO governance o        Buffer Pool Extension to SSDs o        Query optimization enhancements o        SysPrep at cluster level o        Predictable performance with tiering of compute, network, and storage with Windows Server 2012 R2 o        Data Compression with USC-2 Unicode support o     ...

PERFORMANCE & SCALE o        In-Memory OLTP o        Enhanced In-Memory ColumnStore for DW o        Support for 640 logical proc. & 4 TB memory o        Support to 15,000 partitions o        Resource Governor IO governance o        Buffer Pool Extension to SSDs o        Query optimization enhancements o        SysPrep at cluster level o        Predictable performance with tiring of compute, network, and storage with Windows Server 2012 R2 o        Data Compression with USC-2 Unicode support o     ...