SELECT TOP 100 execution_count, total_worker_time, last_worker_time, max_worker_time, min_worker_time, CONVERT(INT, att.value) AS dbid, DB_NAME(CONVERT(INT, att.value)) as dbname ,SUBSTRING(st.text, (qs.statement_start_offset/2) + 1,((CASE statement_end_offset WHEN -1 THEN DATALENGTH(st.text)ELSE qs.statement_end_offset END - qs.statement_start_offset)/2) + 1) as statement_text

FROM sys.dm_exec_query_stats as qs 

CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as st

CROSS APPLY sys.dm_exec_plan_attributes(qs.plan_handle) att

WHERE att.attribute='dbid' and DB_NAME(CONVERT(INT, att.value)) = 'P9'

ORDER BY execution_count DESC 

SELECT TOP 10 execution_count, total_worker_time, last_worker_time, max_worker_time, min_worker_time, SUBSTRING(st.text, (qs.statement_start_offset/2) + 1,((CASE statement_end_offset WHEN -1 THEN DATALENGTH(st.text)ELSE qs.statement_end_offset END - qs.statement_start_offset)/2) + 1) as statement_text

FROM sys.dm_exec_query_stats as qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as st

WHERE statement_start_offset = 0

ORDER BY execution_count DESC  

SELECT TOP 10 total_worker_time, last_worker_time, max_worker_time, min_worker_time, SUBSTRING(st.text, (qs.statement_start_offset/2) + 1,((CASE statement_end_offset WHEN -1 THEN DATALENGTH(st.text)ELSE qs.statement_end_offset END - qs.statement_start_offset)/2) + 1) as statement_text

FROM sys.dm_exec_query_stats as qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as st

ORDER BY max_worker_time DESC 

netstat -an
tcp 0.0.0.0:80 需沒有
tcp 192.168.0.203:80 需有

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\HTTP\Parameters\ListenOnlyList
會列出開機時會載入的 httpcfg set iplisten，若 ip 有設錯 iis 可能會出現 "指定的網路名稱格式不正確"
 

$(document).ready(function () {

CKEDITOR.replace('<% = me.txtContent.ClientId %>', {

on: {

instanceReady: function (ev) {

this.dataProcessor.writer.setRules('p', {

indent: false, //縮排

breakBeforeOpen: true, // <P>之前是否換行

breakAfterOpen: true, // <P>之後是否換行

breakBeforeClose: false, // </P>之前是否換行

breakAfterClose: true // </P>之後是否換行

});

}

},

toolbar: 'basic'

});

});



$(document).ready(function () {

if (parseInt(window.navigator.appVersion.match(/Chrome\/(\d+)\./)[1]) >= 12) {

function bindPasteInCK() {

$("iframe").contents().find("body").bind('paste', imagePasteOnPaste);

}



CKEDITOR.instances.<% = me.txtContent.ClientId %>.on("instanceReady", bindPasteInCK);

}

});

Public Shared Funciont AA() as string

　return xxxxx

End Function

public static string aa()

{

　return xxxx

}

Public Shared Sub AA()

......

End Sub

public static void AA()

{

.....

}

Try

　xxxxxx

Catch ex As Exception

　UW.WU.WriteErrorToLog(ex)

End Try

try

{

　xxxxxx

}

catch (Exception ex)

{

　tran.Rollback();

}

char[] delimiterChars = { ',' };

foreach (string tags in cbTags.Split(delimiterChars))

{



}

select case AA

　case "AA"

　　xxx

　case "BB"

　　bbb

　case else

　　aaaa

end select

switch (AA) {

　case "AA":

　　xxx();

　　break;

　case "BB":

　　bbb();

　　break;

　default:

　　aaaa();

　　break;

}

<input id="Text1" type="text" />

<input id="Button1" onclick="location.href='msnim:chat?contact=' + $('#Text1').val()" type="button" value="談話" />

<a href="msnim:add?contact=MSN帳號">加入我的MSN</a>

<a href="skype://Skype帳號?add">

<img src="/Upload/Article/20120517/20120517025520_0.jpg" alt="加入我的Skype" border="0">

</a> 

<a href="skype:Skype帳號?call">

<img src="/Upload/Article/20120517/20120517025520_0.jpg" alt="用Skype打給我吧" border="0" />

</a>

<img src="http://mystatus.skype.com/balloon/Skype帳號" alt="Skype在線狀態" border="0" />

<a href="Skype:Skype帳號?sms">

<img src="/Upload/Article/20120517/20120517025520_0.jpg" border="0" />

</a>

netsh interface tcp show global

netsh interface tcp set global autotuning=disabled

netsh interface tcp set global autotuningl=normal

<script type="text/javascript" src="/scripts/jquery.ae.image.resize.min.js"></script>

<script type="text/javascript">

   $(document).ready(function () {

      $("div._content img").aeImageResize({ width: 250 });

   });

</script>

 

<script type="text/javascript">

  $(document).ready(function () {

    $(".resizeme").aeImageResize({ width: 450 });

  });

</script>