2018年10月
How to monitor tempdb in MS SQL
摘要： Error: tempdb is full due to active_transaction. 参考链接：https://www.mssqltips.com/sqlservertip/4356/track-sql-server-tempdb-space-usage/ 阅读全文
posted @ 2018-10-17 10:53 vicent_199077 阅读(225) 评论(0) 推荐(0)
2017年3月
drop all database objects
摘要： /*Use this sql to drop all objects in a database.*/ -- Drop all SPdeclare @dropSp varchar(max)=''select @dropSp=@dropSp+'DROP PROCEDURE '+QUOTENAME(SC 阅读全文
posted @ 2017-03-16 11:51 vicent_199077 阅读(319) 评论(0) 推荐(0)