Browse by Tags

Tagged Content List
  • Wiki Page: SQL Server Columnstore Index FAQ

    The SQL Server xVelocity memory-optimized columnstore index stores data by columns instead of by rows, similar to a column-oriented DBMS. The columnstore index speeds up data warehouse query processing in SQL Server 2012 through the current version, in many cases by a factor of 10 to 100. We'll...
  • Wiki Page: SQL Server Columnstore Performance Tuning

    Table of Contents Introduction Fundamentals of Columnstore Index-Based Performance DOs and DON'Ts for using Columnstores Effectively Maximizing Performance and Working Around Columnstore Limitations Ensuring Use of the Fast Batch Mode of Query Execution Physical Database Design, Loading, and Index...
  • Wiki Page: Integrating PDW into an Existing SQL Server Landscape

    Parallel Data Warehouse (PDW) is Microsoft's true Data Warehouse appliance, capable of unparalleled performance with the support and backing of Microsoft and the hardware vendor. PDW is a scalable appliance ranging from a 2 rack 'entry level' solution to a 10 rack scaled solution and the...
  • Wiki Page: System Center Service Manager Data Warehouse and Reporting

    The System Center Service Manager Data Warehouse is a powerful IT business intelligence platform built on the Microsoft BI stack (SQL Server, SharePoint, Excel). This article serves as a home page for resources on how to manage and extend the data warehouse as well as how to author custom dashboards...
Page 1 of 1 (4 items)
Can't find it? Write it!