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,589 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
2,850 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Alaydrus Tlpn/wa:085373737551
Jl. Alaydrus No.47 & 47 A, Petojo Utara, Kecamatan Gambir, Kota Jakarta Pusat, Daerah...
MENARA BCA d/a GRAND INDONESIA, Tlpn/wa:085373737551
Tlpn/wa:085373737551 Jl. MH Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota Jakarta Pusat, Daerah Khusus...
BCA KCP Sentral Cikini Tlpn/wa:085373737551
Jl. Pegangsaan Timur No.1, Cikini, Kec. Menteng, Kota Jakarta Pusat, Daerah Khusus Ibukota Jakarta...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers