Solved

How SQL Server Analysis Services stores the data internally?

Posted on 2010-08-17
1
627 Views
Last Modified: 2012-05-10
Can someone tell me how the SQL Server Analysis Services (2005/2008) stores the mutli dimensional data internally? I can see AHSTORE, KHSTORE, LSTORE, KSTORE etc files for dimensions and DATA and HDR files for Mesure group partitions. Can someone elaborate these?
0
Comment
Question by:Srinivas_Vengala
1 Comment
 
LVL 13

Accepted Solution

by:
sameer2010 earned 500 total points
ID: 33456314
Read this...
http://social.msdn.microsoft.com/forums/en-us/sqlanalysisservices/thread/30DF86F1-2771-4202-BC5E-F3F75D1EB836

Open in new window

0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question