評(píng)估插入會(huì)增長(zhǎng)的頁級(jí)空間 1 ; WITH NonClustedIndexColumn AS 2 ( sys.index_columns d (a.index_id dataid,a.name dataneme, b. * FROM sys.indexes a sys.indexes b b.index_id ) c d.index_id = c.index_id dataid,column_id,c. object_id 11 ),NonClust

評(píng)估插入會(huì)增長(zhǎng)的頁級(jí)空間

1 ;WITH NonClustedIndexColumn AS 2 ( sys.index_columns d (a.index_id dataid,a.name dataneme, b.* FROM sys.indexes a sys.indexes b b.index_id ) c d.index_id = c.index_id dataid,column_id,c.object_id 11 ),NonClustedIndexSize 12 AS( (a.object_id) name ,a.object_id,MAX(c.dataneme) index_name, c.dataid ,) a.max_length ) ,(,) ) ,)) ,,,,) ) , sys.columns a sys.types b ON a.user_type_id = b.user_type_id NonClustedIndexColumn c a.column_id = c.column_id dataid a.object_id,c.dataid 27 ) 28 , ClustedHeapSize AS( (a.object_id) name ,a.object_id,MAX(c.name) index_name, c.index_id ,) a.max_length ) ,(,) ) ,)) ,,,,) ) , sys.columns a sys.types b ON a.user_type_id = b.user_type_id sys.indexes c a.c.index_id a.object_id,c.index_id ) 43 ,RowSize AS 44 ( (name),) 46 FROM ( NonClustedIndexSize ClustedHeapSize 50 ) a ) rowsize

posted on

聲明：本網(wǎng)頁內(nèi)容旨在傳播知識(shí)，若有侵權(quán)等問題請(qǐng)及時(shí)與本網(wǎng)聯(lián)系，我們將在第一時(shí)間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com