THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Column Store   (RSS)
  • Updateable Column Store Indexes in SQL Server 2014

    Introduction Column store indexes had been released with SQL Server 2012 to optimize data warehouse workloads that have specific patterns, data are loaded through T-SQL scripts or through SSIS packages, several times a day, in any case the frequency is not important, only that the available data is loaded in the same execution. At the end of ETL ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on June 16, 2014
  • SQL Server v.Next ("Denali") : How a columnstore index is not like a normal index

    At the end of my Denali presentation at SQL Saturday #65 in Vancouver, a member of the audience asked, ''What makes a columnstore index different from a regular nonclustered index?'' At the end of a busy day, I was at a loss for an answer, and I'll explain why. First, I'll briefly explain the basic, core, high-level functionality of a columnstore ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on February 28, 2011
  • Blogging from the PASS Keynote : 2009-11-05

    Bill Graziano took the stage and promised us the shortest keynote yet.  He started by giving thanks to outgoing board members Greg Low, Pat Wright and Kevin Kline.  Wayne Snyder took over and gave an emotional homage to Kevin, who gave 10 solid years to PASS.  Very touching.  Kevin left the stage to a standing ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on November 5, 2009
Privacy Statement