Author: SSWUG Research

Community

Query tuning example

(Bobby Durrett) A coworker of mine cleaned up a bunch of old data to improve performance on an older system of ours and one of the queries started running slower. It looks like the optimizer was choosing a full table scan when an index existed that was much faster.

Community

PDW and SSAS

(Chris Webb) One new feature of SQL Server PDW 2012 that hasn’t had the attention it deserves is the fact that it is now officially supported as a data source for Analysis Services, both Multidimensional (in ROLAP and MOLAP modes) and Tabular (in In-Memory and DirectQuery modes).