[AI] How AI Supports Your Work - List all SQL Server database sizes in MB, GB, and TB. || AI 如何輔助你的工作 - 以MB,GB,TP列出SQL Server所有DB Size

 Copilot顯示，DB SIZE = 574073 GB = 560.6 TB

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

-- 每個資料庫大小（排除系統庫） SELECT d.name AS 資料庫名稱, CAST(SUM(mf.size) * 8.0 / 1024 / 1024 AS DECIMAL(18,4)) AS 使用空間_TB, CAST(SUM(mf.size) * 8.0 / 1024 AS DECIMAL(18,2)) AS 使用空間_GB, CAST(SUM(mf.size) * 8.0 AS DECIMAL(18,0)) AS 使用空間_MB FROM sys.databases d JOIN sys.master_files mf ON d.database_id = mf.database_id WHERE d.database_id > 4 GROUP BY d.name ORDER BY 使用空間_GB DESC; -- 🔢 所有資料庫的總使用空間（MB / GB / TB） SELECT '所有使用者資料庫總空間' AS 標題, CAST(SUM(mf.size) * 8.0 AS DECIMAL(18,0)) AS 總空間_MB, CAST(SUM(mf.size) * 8.0 / 1024 AS DECIMAL(18,2)) AS 總空間_GB, CAST(SUM(mf.size) * 8.0 / 1024 / 1024 AS DECIMAL(18,4)) AS 總空間_TB FROM sys.databases d JOIN sys.master_files mf ON d.database_id = mf.database_id WHERE d.database_id > 4;

Copilot 提供語法之結果

======================================

Grok語法顯示，DB SIZE = 560.62 GB = 0.55 TB

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

SELECT DB_NAME(database_id) AS DatabaseName, CAST(SUM(size) * 8.0 / 1024 AS DECIMAL(10, 2)) AS DatabaseSizeMB, CAST(SUM(size) * 8.0 / (1024 * 1024) AS DECIMAL(10, 2)) AS DatabaseSizeGB, CAST(SUM(size) * 8.0 / (1024 * 1024 * 1024) AS DECIMAL(10, 2)) AS DatabaseSizeTB FROM sys.master_files WHERE database_id > 4 -- Exclude system databases GROUP BY database_id UNION ALL SELECT 'Total Size' AS DatabaseName, CAST(SUM(size) * 8.0 / 1024 AS DECIMAL(10, 2)) AS DatabaseSizeMB, CAST(SUM(size) * 8.0 / (1024 * 1024) AS DECIMAL(10, 2)) AS DatabaseSizeGB, CAST(SUM(size) * 8.0 / (1024 * 1024 * 1024) AS DECIMAL(10, 2)) AS DatabaseSizeTB FROM sys.master_files WHERE database_id > 4 order by DatabaseSizeMB asc; SELECT 'Total Size' AS DatabaseName, CAST(SUM(size) * 8.0 / 1024 AS DECIMAL(10, 2)) AS DatabaseSizeMB, CAST(SUM(size) * 8.0 / (1024 * 1024) AS DECIMAL(10, 2)) AS DatabaseSizeGB, CAST(SUM(size) * 8.0 / (1024 * 1024 * 1024) AS DECIMAL(10, 2)) AS DatabaseSizeTB FROM sys.master_files WHERE database_id > 4; -- Exclude system databases

Grok 提供語法之結果

===============================================

BUT!
BUT!!
BUT!!!
= =........DB硬碟僅有1.17 TB

DB 硬碟空間顯示

===============================================

工廠單位曾說那個海量資料備份不易 (言下之意應該沒做備份..)

一開始用Copilot查出來DB size 560.6 TB，是蠻海的耶!!

正寫信通知工廠單位要評估備份作業，寫到一半...

有個聲音問我：

『單條生產線....可能嗎??』

        『單條生產線....可能嗎??』

                『單條生產線....可能嗎??』

又用了Grok取得一組指令，才發現...

欸!!!!!怎麼少算了一個1024啦!!!

===============================================

結論：

1. 使用AI雖然在各方面的求解方便且快速

但仍得要有點基礎知識，甚至產業特性、經驗累積等

才能判斷AI給你的答案是否正常，有符合現實！

2. 海量的定義? User跟IT的預設看來根本就不在同個起跑點上   哈哈哈

3. 要是沒天音提醒，剛就把信發出去了，等廠商到現場勘查肯定被翻白眼XDD