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 小司阅读(803) 评论(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 小司阅读(905) 评论(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 小司阅读(807) 评论(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 小司阅读(298) 评论(0) 推荐(1) 编辑