sql server
xiaodai511
这个作者很懒,什么都没留下…
展开
-
sql server数据库排序规则转换COLLATE
数据库排序规则转换COLLATE SELECT [database_id], [DBName], [DBDescription], [CreateDate], [RecoveryModel], [DataFileSizeMB], [LogFileSizeMB],原创 2020-05-18 14:39:10 · 443 阅读 · 0 评论 -
sql server查看指定对象调用情况
--查看指定表名被哪些视图、存储过程调用 SELECT name FROM sysobjects AS s INNER JOIN syscomments AS o ON s.id = o.id WHERE text LIKE N'%DWS_T_LRFJ_ACT_M_TOTALSALSVOLSUM%';原创 2020-06-11 13:27:29 · 309 阅读 · 0 评论 -
sql server查看服务器磁盘使用
--查看数据库服务器磁盘使用情况 WITH T1 AS ( SELECT DISTINCT REPLACE(vs.volume_mount_point,':\','') AS Drive_Name , CAST(vs.total_bytes / 1024.0 / 1024 / 1024 AS NUMERIC(18,2)) AS Total_Space_GB , CAST(vs.available_bytes / 1024.0 / 1024 / 1024 AS NUMERIC(18,2)) AS Free原创 2020-06-11 13:25:19 · 547 阅读 · 0 评论