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,282 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,275 reads
Blogs
Power BI Monthly Digest – August 2020
By Devin-Knight
In this month’s Power BI Digest Matt and I will again guide you through...
Daily Coping 14 Aug 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Setting default values for Array parameters/variables in Azure Data Factory
By Rayis Imayev
(2020-Aug-14) Setting default values for my parameters or variables in Azure Data Factory (ADF)...
Forums
Removing TDE from a Database: Level 4 Stairway to TDE
Comments posted to this topic are about the item Removing TDE from a Database:...
Location Data Privacy
Comments posted to this topic are about the item Location Data Privacy
TextBox Property>Action>GotoURL for Multiple Values?
Hi I am using two stuff commands in my query. One gets the date...
Ask SSC