A Generic SQL Performance Test Harness. Do you know how to measure the impact on performance of your SQL changes?
Do you know which parts of your stored procedures (or batch of SQL statements) you need to optimise? Both of these questions are answered in this article. Background Since this article uses Dynamic Management Views (DMVs), you need SQL Server version 2005 or above to use the described generic test harness. Column Store vs. Column Store. It has been 5 years since Vertica was founded and it is great to see that Column Stores are becoming prevalent and widely regarded as the preferred architectures for data warehousing and analytics.
Mainstream and upstart vendors alike are announcing columnar storage and columnar compression as “features” of their row-oriented DBMS. While this is excellent news for the column store enthusiasts, marketing messages are rife with false information that creates confusion for buyers. The column-store pioneer.