2016年5月15日
清除数据库缓存
摘要： DBCC FREEPROCCACHE; DBCC DROPCLEANBUFFERS; DBCC FREESYSTEMCACHE ('ALL'); 阅读全文
posted @ 2016-05-15 23:11 Elvis.Lee 阅读(547) 评论(0) 推荐(0)
启用数据库的 SQL Server Service Broker
摘要： ALTER DATABASE DevAssistant SET NEW_BROKER WITH ROLLBACK IMMEDIATE; ALTER DATABASE DevAssistant SET ENABLE_BROKER; 阅读全文
posted @ 2016-05-15 23:10 Elvis.Lee 阅读(216) 评论(0) 推荐(0)
SQL SERVER 收缩日志
摘要： ALTER DATABASE DevAssistant SET RECOVERY SIMPLE;--设置简单恢复模式 GO DBCC SHRINKFILE (DevAssistant_Log, 1); GO ALTER DATABASE DevAssistant SET RECOVERY FULL; 阅读全文
posted @ 2016-05-15 23:08 Elvis.Lee 阅读(145) 评论(0) 推荐(0)
SQL SERVER 查询死锁
摘要： 方法一： WITH CTE_SID ( BSID, SID, sql_handle ) AS ( SELECT blocking_session_id , session_id , sql_handle FROM sys.dm_exec_requests WHERE blocking_session 阅读全文
posted @ 2016-05-15 23:06 Elvis.Lee 阅读(1125) 评论(0) 推荐(0)
SQL SERVER 获取对象(存储过程、函数等)参数信息
摘要： CREATE PROCEDURE [Common].[ProcLoadFunctionParameters] @inObjectName sysname AS BEGIN SELECT sp.object_id AS FunctionId , sp.name AS FunctionName , (C 阅读全文
posted @ 2016-05-15 22:59 Elvis.Lee 阅读(787) 评论(0) 推荐(0)
SQL SERVER 获取表字段信息
摘要： CREATE PROCEDURE [Common].[ProcLoadColumnInfo] @inObjectName sysname AS BEGIN SELECT TableCatalog = DB_NAME() , TableSchema = SCHEMA_NAME(C.schema_id) 阅读全文
posted @ 2016-05-15 22:57 Elvis.Lee 阅读(474) 评论(0) 推荐(0)