index_type_desc,
alloc_unit_type_desc,
min_record_size_in_bytes,
max_record_size_in_bytes,
avg_record_size_in_bytes
FROM SYS.DM_DB_INDEX_PHYSICAL_STATS
(DB_ID('AdventureWorks'),NULL,NULL,NULL,'DETAILED')
ORDER BY avg_record_size_in_bytes DESC;
GO
Database Design Considerations
數據庫設計需要考慮的問題:
究竟什么時候應該考慮評測你的數據庫設計方案(寬的表)。具體的幾個方面如下:
文章來源于領測軟件測試網 http://www.kjueaiud.com/