- 博客(5)
- 收藏
- 关注
原创 Cheatable XML task in SSIS
<br />You may get fooled when using variables as the XML source in XML task. It does not work at all and you probably catch the error as below<br />Error:0xC002F304 at XML Task, XML Task: An error occurred with the following error message:"Data at the root
2011-02-22 03:52:00 903
原创 How to make the SSIS load infopath XML files into DB?
<br />Infopath is a good choice for quick designing questionnaire and collecting the information back. Yet you may meet challenge when you wanna import the pile of the XML files into DB because the XML files includes more than one namespaces, which SSIS XM
2011-02-22 00:23:00 435
转载 Understanding SQL Backup
<br />http://technet.microsoft.com/en-us/magazine/2009.07.sqlbackup.aspx<br />
2010-08-12 21:27:00 285
原创 to get the most expensive t_SQL
<br />it is easy and popular to know that you can query on DMV to pull out the most expensive queires as below.<br /> <br />SELECT TOP 10 SUBSTRING(qt.TEXT, (qs.statement_start_offset/2)+1,<br /> ((CASE qs.statement_end_offset<br /> WHEN -1 THEN DATALENG
2010-08-11 11:16:00 296
原创 A workaround for limitation of 900 bytes index key
Normal 0 false false false EN-US ZH-CN X-NONE
2010-04-13 20:39:00 531
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人