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 可能會出現 "指定的網路名稱格式不正確"
 

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

IIf(X IsNot Nothing, X.qty, 0) --> 會有 Error



If(X IsNot Nothing, X.qty, 0) --> OK

這是 VS2010 的 Bug 嗎 ?

<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>