SQL scripts, coding and programming for database administrators
This sequence of scripts can help identify tables that are being blocked and quantify how many locks are happening in your database.
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.
This script will monitor CPU Usage Information.
Use this script to generate a random password.
Use this stored procedure to quickly capture all login information when needed, especially for security audit situations.
Practice INSERT into.
Piece of code to search all stored procedures in all databases for keyword.
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.
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.
Used when checking to see if the registered user is already in the database.
Creating Excel using TSQ-L.
Disk Space Used for all databases.
This script looks for all failed jobs in the last day.
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.
Uploading a flat file into an Oracle database.
Add Your Script
SQL Scripts & Samples Archives