[SQL] By Date列出每個日期的資料數量
有時檢查資料是否異常 需要統計每個月分的資料數量是否有異常 Select count (created_date) as counted_leads, created_date as count_date from table group by created_date footer See also :
發表文章
[SQL] 查詢SQL IO 效能問題 (查詢出高IO的QUERY語句)
DMV to check queries causing high IO 查詢出高IO的QUERY語句 SELECT TOP 25 cp.usecounts AS [execution_count] ,qs.total_worker_time AS CPU ,qs.total_elapsed_time AS ELAPSED_TIME ,qs.total_logical_reads AS LOGICAL_READS ,qs.total_logical_writes AS LOGICAL_WRITES ,qs.total_physical_reads AS PHYSICAL_READS , SUBSTRING (text, CASE WHEN statement_start_offset = 0 OR statement_start_offset IS NULL THEN 1 ELSE statement_start_offset / 2 + 1 END , CASE WHEN statement_end_offset = 0 OR statement_end_offset = -1 OR statement_end_offset IS NULL THEN LEN(text) ELSE statement_end_offset / 2 END - CASE WHEN statement_start_offset = 0 OR statement_st...
RDP Server 那裡尋找 License Server ID
最近要做RDS Server移轉 故需要進行授權移轉 這裡會用到license server id 在哪裡呢 1.在RDS Server。要打開遠程桌面授權管理器，請單擊“開始”，指向“管理工具”，指向“ Remote Desktop Services ”， 然後單擊“ Remote Desktop Licensing Manager ” 。 2.滑鼠右鍵查看其許可證Server的license server，然後單擊“ Properties ” 。 3.單擊 Connection Method 選項 。許可證服務器 ID 列在對話框的下部。 footer See also :