Keywords Search

SSMS卡死：http://www.cnblogs.com/Uest/p/4975301.html#SSMSHang
备份/还原进度：http://www.cnblogs.com/Uest/p/5033630.html#PercentComplete
I/O Latency：http://www.cnblogs.com/Uest/p/5763100.html#IOLatency
逻辑处理器核数：http://www.cnblogs.com/Uest/p/6945087.html#LogicalCores
压缩备份：http://www.cnblogs.com/Uest/p/3597261.html#Compression
占用空间前N的表：http://www.cnblogs.com/Uest/p/5726734.html
缺失索引：http://www.cnblogs.com/Uest/p/5190575.html
并行查询：http://www.cnblogs.com/Uest/p/6145963.html#Parallel
带Sid和PassWord的登录名：http://www.cnblogs.com/Uest/p/5190875.html#LoginSid
通过HostName查客户端IP：http://www.cnblogs.com/Uest/p/5191069.html

SELECT a.name database_name,
       a.state_desc,
       a.log_reuse_wait_desc,
       a.create_date,
       SUSER_SNAME(a.owner_sid) owner_name,
       a.collation_name,
       a.recovery_model_desc,
       a.compatibility_level,
       DATABASEPROPERTYEX(a.name,'Version') database_version,
       a.user_access_desc,
       CASE a.is_read_only WHEN 1 THEN 'READ_ONLY' WHEN 0 THEN 'READ_WRITE' END AS read_only_desc,
       a.page_verify_option_desc,
       a.is_auto_close_on,
       CASE WHEN (a.is_published = 1 OR a.is_merge_published = 1) THEN 1 ELSE 0 END AS is_published,
       a.is_distributor,
       is_encrypted,
       is_cdc_enabled
  FROM MASTER.sys.databases a

View Code