|
SQL scripts, coding and programming for database administrators
08/22/2016
Not all tools provide a GUI interface, making it difficult to find Oracle's object referenced inside a PLSQL stored procedure. This script finds those objects.
04/29/2016
This script will monitor CPU Usage Information.
12/14/2015
Use this script to generate a random password.
04/24/2015
Use this stored procedure to quickly capture all login information when needed, especially for security audit situations.
04/02/2014
Practice INSERT into.
05/22/2013
Piece of code to search all stored procedures in all databases for keyword.
04/16/2013
Helps DBA to find out quickly which database takes a lot of space and which file could be shrunk. Very useful when output is sorted by Drive Letter when "Out of space" occurs.
11/24/2012
Want to use this function in PHP/MySQL but new to PHP/MySQL. It works by taking the select member code description and the last assigned number and format as CON-00001 once the focus in lost after selecting the member description from dropdown list on the form.
11/10/2012
Used when checking to see if the registered user is already in the database.
12/26/2011
Creating Excel using TSQ-L.
12/08/2011
Disk Space Used for all databases.
10/17/2011
This script looks for all failed jobs in the last day.
06/25/2011
This script will create the base table, stored procedures, set up alert, Job for the dead lock. The output will send both xml and xdl file. XDL file is the deadloack graph that can be opened in SSMS.
06/14/2011
Uploading a flat file into an Oracle database.
02/01/2010
This script tests connectivity to SQL Server box from a client machine when there is no SQL Client.
Add Your Script
SQL Scripts & Samples Archives
|
» 