First introduced in SQL Server 2012, columnstore indexes can give you major performance gains -- provided you have the right workloads. Here's how columnstore indexes work and what types of data work ...

As we’ve come to expect from new SQL Server releases, SQL Server 2012 has so many new features that it’s impossible even to mention them all. Nearly everyone is well served, from the BI-hungry users ...

I'm currently working on a particular table that is about 7 million records. Size on disk is about 2GB. It so happens that the way this is indexed, The size of the index is about double the size of ...

Building on the DATETIMEFROMPARTS, DATETIME2FROMPARTS offers similar functionality, but yields more precise DateTime2 data type, containing fractions of a second to a specified precision. Naturally, ...