2010 年 5月 18 日随笔档案 - 小司

2010年5月18日

摘要： How To Implement Proactive Caching in SQL Server Analysis Services (SSAS) 2005Written By: Ray Barley ProblemWe have chosen MOLAP storage in order to maximize the query performance of our cubes. Since ... 阅读全文

posted @ 2010-05-18 23:21 小司阅读(820) 评论(1) 推荐(2)

SSIS 包配置

摘要： SQL Server Integration Services SSIS Package ConfigurationWritten By: Ray Barley ProblemAs we develop, test and deploy SSIS packages, we need to specify different parameter values for things like data... 阅读全文

posted @ 2010-05-18 22:11 小司阅读(937) 评论(1) 推荐(1)

如何应用SSIS中的事务选项

摘要： How To Use Transactions in SQL Server Integration Services SSIS Written By: Ray Barley ProblemI'm trying to build an SSIS package where the entire package is encapsulated in a transaction. In addition... 阅读全文

posted @ 2010-05-18 11:39 小司阅读(828) 评论(0) 推荐(2)

SSRS Predefined Roles Overview

摘要： Predefined Roles OverviewReporting Services includes a small set of predefined roles that relate to report-related functions commonly performed in an organization. You can modify these roles or replac... 阅读全文

posted @ 2010-05-18 11:20 小司阅读(303) 评论(0) 推荐(1)