SQL Server資料庫管理常用的SQL和T-SQL語句
來源:網際網路 作者:west263.com 時間:2008-04-02
1. 檢視資料庫的版本
select @@version
2. 檢視資料庫所在機器作業系統參數
exec master..xp_msver
3. 檢視資料庫啟動的參數
sp_configure
4. 檢視資料庫啟動時間
select convert(varchar(30),login_time,120) from master..sysprocesses where spid=1
檢視資料庫伺服器名和執行個體名
print 'Server Name...............: ' convert(varchar(30),@@SERVERNAME)
print 'Instance..................: ' convert(varchar(30),@@SERVICENAME)
5. 檢視任何資料庫名稱及大小
sp_helpdb
重命名資料庫用的SQL
sp_renamedb 'old_dbname', 'new_dbname'
6. 檢視任何資料庫使用者登入資訊
sp_helplogins
檢視任何資料庫使用者所屬的角色資訊
sp_helpsrvrolemember
修複遷移伺服器時孤立使用者時,能夠用的fix_orphan_user腳本或LoneUser過程
更改某個資料對象的使用者屬主
sp_changeobjectowner [@objectname =] 'object', [@newowner =] 'owner'
注意: 更改對象名的任一部分都可能破壞腳本和存儲過程。
把一台伺服器上的資料庫使用者登入資訊備份出來能夠用add_login_to_aserver腳本
7. 檢視連結伺服器
sp_helplinkedsrvlogin
檢視遠端資料庫使用者登入資訊
sp_helpremotelogin
8.檢視某資料庫下某個資料對象的大小
sp_spaceused @objname
還能夠用sp_toptables過程看最大的N(預設為50)個表
檢視某資料庫下某個資料對象的索引資訊
sp_helpindex @objname
還能夠用SP_NChelpindex過程檢視更周詳的索引情況
SP_NChelpindex @objname
clustered索引是把記錄按實體順序排列的,索引占的空間比較少。
對鍵值DML操作十分頻繁的表我建議用非clustered索引和限制,fillfactor參數都用預設值。
檢視某資料庫下某個資料對象的的限制資訊
sp_helpconstraint @objname
9.檢視資料庫裡任何的存儲過程和函數
use @database_name
sp_stored_procedures
檢視存儲過程和函數的源代碼
sp_helptext '@procedure_name'
檢視包含某個字元串@str的資料對象名稱
select distinct object_name(id) from syscomments where text like '%@str%'
建立加密的存儲過程或函數在AS前面加WITH ENCRYPTION參數
解密加密過的存儲過程和函數能夠用sp_decrypt過程
10.檢視資料庫裡使用者和程序的資訊
sp_who
檢視SQL Server資料庫裡的活動使用者和程序的資訊
sp_who 'active'
檢視SQL Server資料庫裡的鎖的情況
sp_lock
程序号1--50是SQL Server系統内部用的,程序号大于50的才是使用者的連接配接程序.
spid是程序編号,dbid是資料庫編号,objid是資料對象編号
檢視程序正在執行的SQL語句
dbcc inputbuffer ()
推薦大家用經過改進後的sp_who3過程能夠直接看到程序運作的SQL語句
sp_who3
檢查死鎖用sp_who_lock過程
sp_who_lock
11.收縮資料庫日志文檔的方法
收縮簡單恢複模式資料庫日志,收縮後@database_name_log的大小機關為M
backup log @database_name with no_log
dbcc shrinkfile (@database_name_log, 5)
12.分析SQL Server SQL 語句的方法:
set statistics time {on | off}
set statistics io {on | off}
圖像方式顯示查詢執行計劃
在查詢分析器->查詢->顯示估計的評估計劃(D)-Ctrl-L 或點選工具欄裡的圖像
文本方式顯示查詢執行計劃
set showplan_all {on | off}
set showplan_text { on | off }
set statistics profile { on | off }
13.出現不一緻錯誤時,NT事件檢視器裡出3624号錯誤,修複資料庫的方法
先注釋掉應用程式裡引用的出現不一緻性錯誤的表,然後在備份或其他機器上先恢複然後做修複操作
alter database [@error_database_name] set single_user
修複出現不一緻錯誤的表
dbcc checktable('@error_table_name',repair_allow_data_loss)
或可惜選擇修複出現不一緻錯誤的小型資料庫名
dbcc checkdb('@error_database_name',repair_allow_data_loss)
alter database [@error_database_name] set multi_user
CHECKDB 有3個參數:
repair_allow_data_loss 包括對行和頁進行配置設定和取消配置設定以改正配置設定錯誤、結構行或頁的錯誤,
連同删除已損壞的文本對象,這些修複可能會導緻一些資料丢失。
修複操作能夠在使用者事務下完成以允許使用者復原所做的更改。
假如復原修複,則資料庫仍會含有錯誤,應該從備份進行恢複。
假如由于所提供修複等級的緣故遺漏某個錯誤的修複,則将遺漏任何取決于該修複的修複。
修複完成後,請備份資料庫。
repair_fast 進行小的、不耗時的修複操作,如修複非聚集索引中的附加鍵。
這些修複能夠很快完成,并且不會有丢失資料的危險。
repair_rebuild 執行由 repair_fast 完成的任何修複,包括需要較長時間的修複(如重建索引)。
文章整理:西部數位--專業提供域名注冊、虛拟主機服務
http://www.west263.com
以上資訊與文章正文是不可分割的一部分,如果您要轉載本文章,請保留以上資訊,謝謝!
sp_toptables過程看最大的N(預設為50)個表
1
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
CREATE proc sp_toptables @topcount int = 50
2
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
as
3
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
declare @pagesize bigint
4
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
declare @dbid int
5
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
6
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
select @pagesize = low
7
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
from master.dbo.spt_values
8
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
where number = 1
9
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
and type = ' E '
10
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
11
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
declare @spt_space table
12
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
(
13
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
objid int null ,
14
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
rows int null ,
15
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
reserved int null ,
16
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
data int null ,
17
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
indexp int null ,
18
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
unused int null
19
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
)
20
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
21
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
insert into @spt_space
22
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
select objid = id,
23
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
rows = sum ( case when indid in ( 0 , 1 ) then rowcnt else 0 end ),
24
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
reserved = sum ( case when indid in ( 0 , 1 , 255 )
25
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
then reserved
26
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
else 0
27
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
end ) * @pagesize / 1024 ,
28
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
data = sum ( case when indid in ( 0 , 1 ) then dpages
29
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
when indid = 255 then used
30
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
else 0
31
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
end ) * @pagesize / 1024 ,
32
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
indexp = sum ( case when indid in ( 0 , 1 , 255 )
33
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
then used
34
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
else 0
35
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
end ) * @pagesize / 1024 ,
36
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
unused = sum ( case when indid in ( 0 , 1 , 255 )
37
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
then used
38
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
else 0
39
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
end ) * @pagesize / 1024
40
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
from sysindexes
41
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
where rowcnt > 0
42
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
group
43
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
by id, indid
44
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
order
45
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
by reserved desc
46
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
47
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
set rowcount @topcount
48
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
select Table_Name = name,
49
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
rows,
50
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
reserved_KB = ltrim ( str (reserved, 15 , 0 ) + ' ' + ' KB ' ),
51
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
data_KB = ltrim ( str (data, 15 , 0 ) + ' ' + ' KB ' ),
52
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
index_size_KB = ltrim ( str (indexp - data, 15 , 0 ) + ' ' + ' KB ' ),
53
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
unused_KB = ltrim ( str (reserved - unused, 15 , 0 ) + ' ' + ' KB ' ),
54
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
idx_data_ratio = ltrim ( str ((indexp - data) * 100 / data) + ' % ' ),
55
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
unused_pct = ltrim ( str ((reserved - unused) * 100 / reserved) + ' % ' )
56
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
from @spt_space s join sysobjects o on o.id = s.objid and xtype = ' U '
57
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
where data > 0
58
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
order
59
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
by reserved desc
60
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIml2ZuUmbv50LcNncvRXYjlGZul0ZulmbpxGd190LcNXZnFWbJ9CX0Vmbu4GZzNmLn9GbiVGdpJ3dvw1LcpDc0RHaiojIsJye.gif)
set rowcount 0