SQL Server
文章平均质量分 76
iacpdj
Come on
展开
-
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 · 544 阅读 · 0 评论 -
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 · 302 阅读 · 0 评论 -
Understanding SQL Backup
<br />http://technet.microsoft.com/en-us/magazine/2009.07.sqlbackup.aspx<br />转载 2010-08-12 21:27:00 · 290 阅读 · 0 评论 -
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 · 442 阅读 · 0 评论