How does a column store index compare to a (traditional)row store index with regards to performance
2016-12-30 (first published: 2015-05-14)
Don't blame SQL Server if your SQL Statements perform badly! But where do you start to investigate the problem? This article is a primer on were to start looking when your SQL runs slowly.
2015-04-28 (first published: 2010-07-29)
Do sub query expressions introduce a performance penalty on retrieving large data sets?
2012-01-20 (first published: 2010-07-22)