2013年8月5日
检查是否丢失索引
摘要： SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTEDSELECT TOP 30ROUND(s.avg_total_user_cost * s.avg_user_impact * ( s.user_seeks+ s.user_scans ),0) AS [Total Cost] ,s.avg_total_user_cost * ( s.avg_user_impact / 100.0 ) * ( s.user_seeks+ s.user_scans ) AS Improvement_Measure ,DB_NAME() AS DatabaseName , 阅读全文
posted @ 2013-08-05 19:08 Vincent.Dr 阅读(347) 评论(0) 推荐(0)
WCF configure
摘要： 1. maxBufferSize一个正整数，指定内存中用于存储消息的缓冲区的最大大小（字节）。如果transferMode属性等于Buffered，则此属性应等于maxReceivedMessageSize属性值。如果transferMode属性等于Streamed，则此属性不能大于maxReceivedMessageSize属性值，应当至少为标头的大小。More info :http://msdn.microsoft.com/en-gb/library/system.servicemodel.configuration.netnamedpipebindingelement.maxbuffer 阅读全文
posted @ 2013-08-05 14:54 Vincent.Dr 阅读(269) 评论(0) 推荐(0)
How to Handle Exception
摘要： 阅读全文
posted @ 2013-08-05 13:48 Vincent.Dr 阅读(156) 评论(0) 推荐(0)
How to use Variables in different component
摘要： 1. In Script Task componentSet Value:Dts.Variables["ErrorMsg"].Value = string.Format("Connection Config Exception:{0}", ex.Message);Dts.Variables["ErrorStatus"].Value = true;Get Value:string FileName = (string)Dts.Variables["FileName"].Value;2. Execute SQL Tas 阅读全文
posted @ 2013-08-05 13:42 Vincent.Dr 阅读(184) 评论(0) 推荐(0)
Mismatched locale IDs. The component locale ID (2052) does not match the connection manager locale ID (2057)
摘要： Snapshot：When using the 'Flat File Source' and 'OLE DB Destination' or something else components to load some data through the components. Maybe we will have the error like that.Mismatched locale IDs. The component locale ID (2052) does not match the connection manager locale ID (205 阅读全文
posted @ 2013-08-05 12:13 Vincent.Dr 阅读(781) 评论(0) 推荐(0)