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 Access
SQL Scripts & Samples
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:

By submitting your information, you agree that databasejournal.com may send you databasejournal offers via email, phone and text message, as well as email offers about other products and services that databasejournal believes may be of interest to you. databasejournal will process your information in accordance with the Quinstreet Privacy Policy.

News Via RSS Feed

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