SQLSERVER
caozhengwei1314
11
展开
-
分布式读写分离架构
欢迎讨论原创 2016-02-24 15:18:01 · 688 阅读 · 0 评论 -
文档
SELECT * FROM sys.dm_io_virtual_file_stats(-1,-1) SELECT * FROM SYS.dm_db_file_space_usage SELECT * FROM SYS.dm_db_task_space_usage SELECT * FROM SYS.dm_db_session_space_usage DB原创 2016-07-07 11:36:57 · 239 阅读 · 0 评论 -
查表字段及说明
SELECT A.name AS table_name, B.name AS column_name, C.value AS column_description FROM sys.tables A INNER JOIN sys.columns B ON B.object_id = A.object_id LEFT JOIN sys.extended_properties C ON C原创 2016-08-04 15:05:47 · 386 阅读 · 0 评论