续：有关SQL SERVER分布统计的问题(三)
5: Column_Name = @Column_Name,
56: Stats_Name = @Stats_Name
57: SELECT TOP 1 @i = ROWID,
58: @Table_Name = Table_Name,
59: @Column_Name = Column_Name,
60: @Stats_Name = Stats_Name
61: FROM @Tab
62: WHERE ROWID > @I
63: END
64: GO
65: SELECT SUM(DATALENGTH(ColStats_Stream) / 1024.) AS [Size KB]
66: FROM #TMP
67: GO
68: SELECT Table_Name,
69: Column_Name,
70: Stats_Name,
71: ColStats_Stream,
72: DATALENGTH(ColStats_Stream) / 1024. AS [Size KB]
73: FROM #TMP
74: ORDER BY [Size KB] DESC
从Size KB列可以知道每一个统计对象使用的字节数。
作者 Yuejun Sun