Login or Sign Up to become a member!
LessThanDot Sit Logo

LessThanDot

Data Management

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

LTD Social Sitings

Lessthandot twitter Lessthandot Linkedin Lessthandot friendfeed Lessthandot facebook Lessthandot rss

Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.

Your profile

    Search

    XML Feeds

    Google Ads

    « TRY_CONVERT in SQL Server Denali CTP3Format function in SQL Server Denali CTP3 »
    comments

    The SQL Server Database Engine has published a SQL Server Columnstore Index FAQ wiki

    The SQL Server columnstore index feature, code-named Apollo, speeds up data warehouse query processing in SQL Server code-named "Denali", in many cases by a factor of 10 to 100. We'll be posting answers to frequently asked questions here. For more information about columnstore indexes, please see Columnstore Indexes on MSDN.

    There are 6 sections
    Overview
    Creating a Columnstore Index
    Limitations on Creating a Columnstore Index
    More Details on Columnstore Technology
    Managing Columnstore Indexes
    Batch Mode Processing

    As additional questions arise they plan to add more content, so make sure to bookmark the page. Head over here http://social.technet.microsoft.com/wiki/contents/articles/sql-server-columnstore-index-faq.aspx to get all the details

    Enjoy

    About the Author

    User bio imageDenis has been working with SQL Server since version 6.5. Although he worked as an ASP/JSP/ColdFusion developer before the dot com bust, he has been working exclusively as a database developer/architect since 2002. In addition to English, Denis is also fluent in Croatian and Dutch, but he can curse in many other languages and dialects (just ask the SQL optimizer) He lives in Princeton, NJ with his wife and three kids.
    Social SitingsTwitterFacebookLinkedInHomePageFlickrLTD RSS Feed
    530 views
    columnstore
    Instapaper

    No feedback yet

    Leave a comment


    Your email address will not be revealed on this site.

    Your URL will be displayed.
    (Line breaks become <br />)
    (Name, email & website)
    (Allow users to contact you through a message form (your email will not be revealed.)