Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
SQL Scripts & Samples
Tips
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

SQL scripts, coding and programming for database administrators

SQL Scripts & Samples

Object Dependencies 11/01/2017

Use this script to find object dependencies.

Database Size Growth 04/19/2017

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.

Disk Space Usage 04/19/2017

Find how much disk space is used on a database in a week. (Between disk space usage differences)

Lock Monitoring Scripts 03/07/2017

This sequence of scripts can help identify tables that are being blocked and quantify how many locks are happening in your database.

Find Objects Referenced Inside a Stored Procedure 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.

Monitor CPU Usage Information 04/29/2016

This script will monitor CPU Usage Information.

Generate Random Passwords 12/14/2015

Use this script to generate a random password.

User Login Permission Detail 04/24/2015

Use this stored procedure to quickly capture all login information when needed, especially for security audit situations.

Practice SQL 04/02/2014

Practice INSERT into.

Search All Stored Procedures in All Databases 05/22/2013

Piece of code to search all stored procedures in all databases for keyword.

All Database Space Used and Free 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.

Access Function 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.

Register New User 11/10/2012

Used when checking to see if the registered user is already in the database.

Creating Excel Using T-SQL 12/26/2011

Creating Excel using TSQ-L.

DataBase Size 12/08/2011

Disk Space Used for all databases.

Add Your Script
SQL Scripts & Samples Archives




Latest Forum Threads
SQL Scripts & Samples Forum
Topic By Replies Updated
sql help!! add 1 August 22nd, 11:58 AM
How To Combine These 2 Queries into 1 Query ? tarek_land 1 June 7th, 08:37 AM
solving query svibuk 1 February 3rd, 06:08 AM
converting from a character string to uniqueidentifier saturnius 4 January 4th, 05:56 AM