小司 - 博客园

2010年5月20日

摘要：表达式示例 (Reporting Services)表达式通常在报表中使用，以控制报表的内容和外观。表达式以 Microsoft Visual Basic 编写，可以使用内置函数、自定义代码、全局变量、报表变量和组变量以及用户定义的变量。本主题提供的表达式示例可以用于报表中的常见任务。Visual Basic 函数：日期、字符串、转换和条件 Visual Basic 函数的示例。报表函数：聚合函数... 阅读全文

posted @ 2010-05-20 17:21 小司阅读(1899) 评论(0) 推荐(1) 编辑

在SSRS中直接给URL传递参数

摘要： Passing parameters and other options directly through a URL in Reporting ServicesWritten By: Rob Fisch ProblemReporting Services has many great built in features, but accessing them externally can be ... 阅读全文

posted @ 2010-05-20 16:23 小司阅读(1639) 评论(0) 推荐(2) 编辑

SSIS要点

摘要： SQL Server Developer Integration Services SSIS Interview QuestionsWritten By: Jeremy Kadlec ProblemOver the years at MSSQLTips.com the tips focusing on interview questions have been popular with the c... 阅读全文

posted @ 2010-05-20 10:24 小司阅读(546) 评论(0) 推荐(1) 编辑

SSIS 脚本任务处理变量

摘要： Using the script task to dynamically build SQL Server Integration Services SSIS package variablesWritten By: Hal Hayes ProblemOne of the advantages of using SSIS is the ability to dynamically create t... 阅读全文

posted @ 2010-05-20 00:24 小司阅读(945) 评论(0) 推荐(1) 编辑

SSIS性能监控

摘要： Perfmon Counters for the Data Flow Engine in SQL Server Integration Services SSISWritten By: Jeremy Kadlec ProblemWe have adopted SQL Server 2005 Integration Services and we are moving a great deal of... 阅读全文

posted @ 2010-05-20 00:15 小司阅读(724) 评论(0) 推荐(1) 编辑

2010年5月19日

导入数据到SQL Server中不同策略

摘要： Different Options for Importing Data into SQL ServerWritten By: Greg Robidoux ProblemMoving data into SQL Server is something that most DBAs or Developers are faced with probably on a daily basis. One... 阅读全文

posted @ 2010-05-19 22:00 小司阅读(257) 评论(0) 推荐(1) 编辑

图解SSIS部署

摘要： SQL Server 2005 - SSIS DeploymentWritten By: Jeremy Kadlec With SSIS functionally the same general steps are followed, but the detailed process is much different. For example, development is completed... 阅读全文

posted @ 2010-05-19 21:50 小司阅读(1829) 评论(1) 推荐(1) 编辑

SSRS 父子层次报表

摘要： Working with a Parent-Child Hierarchy in SQL Server Reporting Services (SSRS) Written By: Ray Barley ProblemI'm trying to create a report that uses a parent-child hierarchy in a dimension of a SQL Ser... 阅读全文

posted @ 2010-05-19 17:42 小司阅读(752) 评论(1) 推荐(1) 编辑

2010年5月18日

SSAS 主动缓存的应用

摘要： 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 小司阅读(811) 评论(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 小司阅读(916) 评论(1) 推荐(1) 编辑