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 ...

While SQL Server 2008 was little more than a service-pack level upgrade, the 2012 version of Microsoft’s database has a boatload of new features and delivers solid performance improvements.

Microsoft announced the latest preview of its next-gen SQL Server product at Ignite. Here's a rundown of everything the new release promises, from performance enhancements to security and availability ...