SQLSERVER
关注
分享
扫一扫
caozhengwei1314
11
展开
-
分布式读写分离架构
欢迎讨论原创 2016-02-24 15:18:01 · 746 阅读 · 0 评论 -
文档
SELECT * FROM sys.dm_io_virtual_file_stats(-1,-1)SELECT * FROM SYS.dm_db_file_space_usageSELECT * FROM SYS.dm_db_task_space_usageSELECT * FROM SYS.dm_db_session_space_usageDB原创 2016-07-07 11:36:57 · 273 阅读 · 0 评论 -
查表字段及说明
SELECTA.name AS table_name,B.name AS column_name,C.value AS column_descriptionFROM sys.tables AINNER JOIN sys.columns B ON B.object_id = A.object_idLEFT JOIN sys.extended_properties C ON C原创 2016-08-04 15:05:47 · 447 阅读 · 0 评论