SQL scripts, coding and programming for database administrators
History to analyze the growth of the databases size over a given period. Additional to the minimum, maximum and average size per week the growth of average size related to the former week is calculated.
Find how much disk space is used on a database in a week. (Between disk space usage differences)
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.
Add Your Script
SQL Scripts & Samples Archives