Browse by Tags

Site sponsored by:

RSS Feeds

backup » dimension (RSS)

Backup and Restore of Analysis Services Database - gotchas

Since the evolution of SQL Server 2000 version the backup and restore methods have been enhanced for better performance to provide a better option for the DBA, as usual the backup and restore operations are an integral part of the Analysis Services infrastructure. The same methods/process has been completely...

Posted to Other SQL Server Blogs around the Web (Weblog) by Anonymous on 12-12-2007
Re: cube help

How often you refresh your fact table depends on your business needs, so be sure to check with your users. Populating the dimension tables is much trickier than populating the fact tables. Some dimensions are relatively small and static. After you have created these, you almost never have to worry about...

Posted to Analysis Services/Data Warehousing (Forum) by satya on 08-02-2007