
SQL Server
文章平均质量分 59
小熊妞
长期觉得睡眠不足,怎么也睡不够,我应该对自己严格一点,调好闹钟,把睡眠时间和周期控制得有规律些。
展开
-
Change the value of "Maximum number of concurrent connections" about SQL Server 2012
Could not connect because the maximum number of '1' user connections has already been reached. The system administrator can use sp_configure to increase the maximum value. The connection has been closed.ingle user mode原创 2017-05-09 11:58:01 · 2027 阅读 · 0 评论 -
SQL Server 批量删除指定数据库
批量删除指定数据库。比如我想要删除数据库名字中包含 “vivi”的所有数据库:if object_id('tempdb..#dbToDelete') is not null drop table #dbToDeleteif object_id('tempdb..#databaseName') is not null drop table #databaseNamedecla...原创 2018-05-11 10:10:01 · 4938 阅读 · 0 评论 -
删除不活动的event sessions
if object_id('tempdb..#dbToDelete') is not null drop table #dbToDeleteif object_id('tempdb..#databaseName') is not null drop table #databaseNamedeclare @dbToDelete table(name varchar(500))...原创 2018-05-29 10:26:43 · 285 阅读 · 0 评论