摘要:
其实之前做过类型的验证,不过影响不是特别深,只是记得不会改变DATA COMPRESSION,那今天再次遇到这个问题就再拿出来验证一下。随便写个脚本验证下。ALTER INDEX ... REBUILD没有改变例子中表的PARTITION SCHEME和DATA COMPRESSION。CREATE... 阅读全文
摘要:
关于问题,有两个相关的服务器选项。 exec sp_serveroption @server='CIA-SH-SVR-SIS', @optname='rpc', @optvalue='true' exec sp_serveroption @server='CIA-SH-SVR-SIS', @op... 阅读全文
摘要:
Checkpoints是实现SSIS包重载的基础。它的原理是把当前运行环境的配置、变量以及到了包运行到哪一步和哪一步失败这些信息写入到一个文件中。而且有一点很重要,Checkpoint只发生在Control Flow级别。要实现包重载,配置上需要配置3个包级别的属性和1个任务属性:Checkpoin... 阅读全文
摘要:
#coding:utf-8#print 'input your name, please'#name = raw_input('请输入你的名字:'.decode('utf-8').encode('gbk'))#print '你好!'.decode('utf-8').encode('gbk'), na... 阅读全文
摘要:
Event HandlerEach task and container raises events as it runs, such as an OnError event, among severalothers that are discussed shortly. SSIS enables ... 阅读全文
摘要:
Requirements:Source and destination system impactProcessing time windows and performanceDestination system state consistencyHard and soft exception ha... 阅读全文
摘要:
In the Control Flow, the task is the smallest unit of work, and a task requires completion (success, failure, or just completion) before subsequent ta... 阅读全文
摘要:
Error outputs can obviously be used to improve reliability, but they also have an important part to play in terms of scalability as wellThe capability... 阅读全文
摘要:
Sequence Container: 它的作用就是可以把一组任务绑定起来成为一个整体,这样Sequence本身就是具有了任务(task)的特性,比如TransactionOption。如果需要把一组任务作为一个整体来对待,就可以用Sequence Container 阅读全文
摘要:
这里简单讲下SCD在讲之前贴上两个有用的链接地址。作者的两篇文件讲解了SCD是什么以及应用http://www.cnblogs.com/biwork/p/3363749.htmlhttp://www.cnblogs.com/biwork/p/3371338.htmlSlow Changing Dim... 阅读全文