SQL Server 2014 will offer Clustered Columnstore Indexes. These will offer the performance and compression benefits of column-oriented storage without the need to restrict the underlying table to ...

ColumnarStore can offer performance improvements over traditional tables, but aren’t always faster. Aleksandr Shavlyuga explores the power, and limitations of SQL Server’s ColumnStore Indexes.

Anyone running a clustered MS SQL setup on top of vSphere? This will be something new for us, but we have a database that can't go down ever. I remember reading about this in passing a couple of ...

I am cleaning out my email, and I came across the emails for the case we worked with Microsoft when we moved from a MSCS SQL instance to a single SQL vm: PROBLEM · Help in migrating a cluster SQL ...

When you use index views in the right situations, they can dramatically improve the performance of SQL Server queries. Tim Chapman explains why performance testing is the best way to tell if ...

Red Gate has announced that its SQL Server development tools now support SQL Server on Amazon RDS, the latest cloud-based database offering from Amazon. In addition, the company says, its SQL ...

LSI will use next week's Microsoft TechEd conference to unveil a new solution that allows high-availability storage clusters to be built with commodity hardware and Microsoft's Windows Server 2012 ...