2020-02-25
708 reads
ColumnStore Index
What are Columnstore Indexes?
Microsoft continues to enhance the performance of SQL Server with new features. In this article, Monica Rathbun explains how to work with columnstore indexes, a different way to store tables that can drastically improve the performance of specific workloads.
2019-08-06
Update Statistics on a Columnstore index failed
SQL Server relies upon good, up-to-date statistics when creating query execution plans. Out-of-date statistics can cause queries to run slowly, or suddenly start consuming far more resources than is...
2019-04-17
2018-12-27
609 reads
2018-05-03
774 reads
Performance Comparison Between SQL Server 2014 and 2016
This article outlines the performance innovations in SQL Server 2016 for Columnstore Index and BatchMode Execution.
2018-02-22
4,815 reads
2018-01-04
840 reads
2015-08-27
1,252 reads
2015-08-13
1,369 reads
2015-08-03
3,281 reads
Blogs
Creating a SQL Clone Agent and a First Image
By Steve Jones
In a previous post, I set up the SQL Clone server. This is really...
Availability Group issues fixed with Alerts
Learn how to use the SQL Server Agent Alerting system to capture Availability Group...
Availability Group issues fixed with Alerts
Learn how to use the SQL Server Agent Alerting system to capture Availability Group...
Forums
Why aren't the backups working?
You've heard of "the accidental DBA", right? Well, I'm the accidental TFS admin. I...
Cannot insert duplicate key in object
In table tUSERI primary key was added in the column [Email]. I deleted a...
Random excessive CPU consumption
Hi all. I'm in a bit of a quandary with one of our Analysis...
Ask SSC