摘要:
DBCC FREEPROCCACHE; DBCC DROPCLEANBUFFERS; DBCC FREESYSTEMCACHE ('ALL'); 阅读全文
摘要:
ALTER DATABASE DevAssistant SET NEW_BROKER WITH ROLLBACK IMMEDIATE; ALTER DATABASE DevAssistant SET ENABLE_BROKER; 阅读全文
摘要:
ALTER DATABASE DevAssistant SET RECOVERY SIMPLE;--设置简单恢复模式 GO DBCC SHRINKFILE (DevAssistant_Log, 1); GO ALTER DATABASE DevAssistant SET RECOVERY FULL; 阅读全文
摘要:
方法一: WITH CTE_SID ( BSID, SID, sql_handle ) AS ( SELECT blocking_session_id , session_id , sql_handle FROM sys.dm_exec_requests WHERE blocking_session 阅读全文
摘要:
CREATE PROCEDURE [Common].[ProcLoadFunctionParameters] @inObjectName sysname AS BEGIN SELECT sp.object_id AS FunctionId , sp.name AS FunctionName , (C 阅读全文
摘要:
CREATE PROCEDURE [Common].[ProcLoadColumnInfo] @inObjectName sysname AS BEGIN SELECT TableCatalog = DB_NAME() , TableSchema = SCHEMA_NAME(C.schema_id) 阅读全文