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,279 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,245 reads
Blogs
How Many Bytes Per Character in SQL Server: a Completely Complete Guide
A Completely Complete Guide to how many bytes are used to represent characters in...
Power BI Monthly Digest – November 2019
By Devin-Knight
In this month’s Power BI Digest Manuel Quintana [Blog | Twitter] and Mitchell Pearson...
Data Masker Reads Column Classificiations
By Steve Jones
One of the newer features in Data Masker for SQL Server is the ability...
Forums
Numeric and Decimal
Comments posted to this topic are about the item Numeric and Decimal, which is...
VM and SQL core license
I am using SQL server 2017 standand edition. We installed on a virtual machine....
look for the most efficient method
Hello everyone , Who can explain to me please the difference between these two...
Ask SSC