To calculate bank routing check digit (digit #9 is used to validate 8-digit bank routing (ABA) number) (for more scripts --> goto http://www.siccolo.com/articles.html)
2007-08-02 (first published: 2006-11-21)
1,424 reads
This script is to monitor drive\database file space. There are variations of this script. The one posted has 2 parts. The frist is one that loops through the databases on a particular server calling the second which is the proc that gathers the information.
2007-08-01 (first published: 2006-11-21)
1,183 reads
Script can be used to find out the objects which are available in other database and are referenced in your stored procedure. These objects will not be listed with sp_depends system stored procedure.
2007-07-31 (first published: 2006-11-21)
287 reads
Created By:Srivathsani M(Srivathsani_m@infosys.com)Arvinder Singh Khosla(arvinder_khosla@infosys.com)Details:The scripts gives the flexibility to create customized backups.1)It gives the provision to give the backup files a customized name with customized time stamp.2)It allows the user to create the backup directory.3)These scripts can be used in the form of stored procedures by passing the variables defined in the script as […]
2007-07-30 (first published: 2006-11-15)
1,477 reads
Quick & Easy way to kill connections to specific database
2007-07-27 (first published: 2006-11-10)
868 reads
This script returns a result set showing which jobs were running at what point during a given day.One column is returned for each Job, and one row for each discrete portion of the day (configured by @TimeGranuality). A value of 1 indicates that the job was running at that point in time, 0 otherwise.Particularly useful […]
2007-07-26 (first published: 2006-11-10)
538 reads
The script can be used to find all the tables that have the particular column name in it.
2007-07-25 (first published: 2006-11-06)
136 reads
This SQL 2005-only VBS script will show the longest-running queries on a given server, complete with graphical .sqlplan when clicked. Results go to a web page, viewed from the local machines's temp directory.Each row of the resulting table has the session ID, the currently running statement of the batch, a link to a text file […]
2007-07-24 (first published: 2006-10-30)
377 reads
Script will create a sorted list of databaes and their recvoery model. I'm sure there is a more elegant way to do this, but this works in a pinch.
2007-07-23 (first published: 2006-10-26)
1,071 reads
This script will drop and recreated all indexes in a database within a transaction. The script will also add standard nameing conventions to the index names. Any duplicated indexes are removed.
2007-07-20 (first published: 2006-10-24)
1,385 reads
It is Friday, the queries are running, and nobody is watching the bill. That...
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
WhatsApp: 0817839777 Jl. Trunojoyo No.15 A, Pejagan, Kec. Bangkalan, Kabupaten Bangkalan, Jawa Timur 69112
WhatsApp: 0817839777 Jl. Suroyo No.28, Tisnonegaran, Kec. Kanigaran, Kota Probolinggo, Jawa Timur 67211
WhatsApp / CS:0817839777 WWH2+WP2, Jl. Pangeran Diponegoro No.54, Tamanan, Kec. Tulungagung, Kabupaten Tulungagung, Jawa...
When running bcp on Linux, what is the field terminator?
See possible answers