Find tables unused since last SQL Server restart
This script will return tables that haven't had any user activity since the SQL Server Service was last restarted. SQL 2005+
2011-07-22 (first published: 2010-01-28)
5,389 reads
Kill all SPIDs with a certain user ID
This script is used to disconnect all connections by a particular individual to a server. I use it when I have to disconnect somebody and they have too many processes to do it by hand. Normally, you can just connect the offending process, but if there are multiple processes that are causing a problem , […]
2004-03-08
1,808 reads
Blogs
Daily Coping 29 Nov 2022
By Steve Jones
Today’s coping tip is to make a meal using a recipe or ingredient you’ve...
My adventures with speaking and what changed
I am writing this blog post as contribution to #NewStarNovember and what got me...
Automatically Take Missed Backups with Ola Hallengren’s Scripts
I blogged a few years ago about my configuration tables for Ola Hallengren’s maintenance...
Forums
Basic Checks on a New AWS RDS SQL Server
Comments posted to this topic are about the item Basic Checks on a New...
Assigning a Server Role
Comments posted to this topic are about the item Assigning a Server Role
Cloud First Software
Comments posted to this topic are about the item Cloud First Software
Ask SSC