萊恩大叔

--查詢目前資料庫內，每一個資料表的使用空間資訊 SELECT a3.name AS N'結構描述', a2.name AS N'資料表', a1.rows AS N'資料列筆數', (a1.reserved + ISNULL(a4.reserved,0))* 8.0/1024 AS N'配置的空間總量(MB)', a1.data * 8.0/1024 AS '資料(MB)', (CASE WHEN (a1.used + ISNULL(a4.used,0)) > a1.data THEN (a1.used + ISNULL(a4.used,0)) - a1.data ELSE 0 END) * 8.0/1024 AS N'索引(MB)', (CASE WHEN (a1.reserved + ISNULL(a4.reserved,0)) > a1.used THEN (a1.reserved + ISNULL(a4.reserved,0)) - a1.used ELSE 0 END) * 8.0/1024 AS N'尚未使用(MB)' FROM (SELECT ps.object_id, SUM ( CASE WHEN (ps.index_id < 2) THEN row_count ELSE 0 END ) AS [rows], SUM (ps.reserved_page_count) AS reserved, SUM ( CASE WHEN (ps.index_id < 2) THEN (ps.in_row_data_page_count + ps.lob_used_page_count + ps.row_overflow_used_page_count) ELSE (ps.lob_used_page_count + ps.row_overflow_used_page_count) END ) AS data, SUM (ps.used_page_count) AS used FROM sys.dm_db_partition_stats ps GROUP BY p

現在奶爸一名，無法講太多廢話，快速記錄一些重點。 Nightwatch是一個前端end to end的工具，可以拿來做測試和自動化工具使用 詳細請參考下列一些資訊，他們寫的比較專業 Nightwatchjs 官方網站 Nightwatch.js 網頁自動化測試(hackmd) Nightwatch 自動化測試( alincode ) Automation Test - Nightwatch(elaine) 使用Nightwatch進行E2E測試 - 菜鳥進化論 e2e 的測試方法 [線上讀書會] andy 主講nightwatch & react 實例演練- YouTube [線上讀書會] 海門主講nightwatch 進階- YouTube