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,302 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,439 reads
Blogs
Book Review: Lights Out
By Steve Jones
I have always been interested in GE since I was a kid. My best...
A Successful Blogger on Making the Switch
By todd-32417
For Kyla Marie Charles, switching to WordPress.com opened up possibilities for her website and...
Login Timeouts
I was recently approached at work about a company that was seeing tons of...
Forums
Oracle: ORA-01843: not a valid month
Hi I have the following query which works fine in Oracle SQL Developer. When...
SQL Server internal variable with DML type
Can you advice how to retrieve the DML type a query is running? Does...
How to Convert Oracle SQL to T-SQL
Hello Community, I have been given a challenge of converting the following SQL code...
Ask SSC