Kill User Processes Per Database or Server Wide
Kill any user processes per database or for the entire server instance.
2013-09-05 (first published: 2013-08-21)
1,494 reads
Kill any user processes per database or for the entire server instance.
2013-09-05 (first published: 2013-08-21)
1,494 reads
Found this lovely T-SQL script to display the SELECT statement for any table.
2013-08-22 (first published: 2013-08-06)
3,211 reads
This script shows size information of every database on the instance.
2013-08-21 (first published: 2010-07-26)
5,800 reads
Create views based on table definitions for backwards compatibility when relocating tables to a new database.
2013-08-16 (first published: 2013-07-30)
1,098 reads
Transact-SQL does not have a simple method to launch multiple parallel running scripts. This tool will change the game. It requires SQL Server 2005 or above.
2013-08-13 (first published: 2009-08-28)
15,784 reads
Use this script to find the Stored Procedures which are referencing the table passed as argument from all databases on the server.
2013-08-12 (first published: 2013-08-02)
1,106 reads
Dynamically drop a user from each database on an SQL instance by their server login SID, then remove there server login as well. Plus some helpful printable information when ran.
2013-08-09 (first published: 2013-07-16)
750 reads
Easiest way to search for a string in any object within the database.
2013-08-08 (first published: 2013-07-29)
2,286 reads
A simple T-SQL script to display the number of days since the last database backup.
2013-08-07 (first published: 2013-07-29)
1,524 reads
Outputs an easily readable result of the database and server roles for database principals.
2013-08-05 (first published: 2013-06-14)
1,049 reads
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers