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

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
SQL Scripts & Samples
Tips
» Database Forum
» Slideshows
Free Newsletters:



DatabaseUpdate  

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2
 

SQL scripts, coding and programming for database administrators

SQL Scripts & Samples

Rss Feed

What Backups Do I Have? 05/12/2021

As a DBA you need to check periodically to make sure you have backups.  I would recommend you do this daily.

Improving the Performance of a Table Variable using Optimizer Hint RECOMPILE 04/01/2021

To improve the performance of your code that uses numerous table variables, consider adding the optimizer hint RECOMPILE.

TYPE Definition Change in Oracle 21c 03/04/2021

Oracle 21c now offers the possibility of using some PL/SQL data types in SQL*PLus, with some restrictions.  Read on to see what types are available and how to use them.

Tip 74 – Changing Cost Threshold for Parallelism 02/24/2021

Anytime the optimizer calculates a plan that exceeds a given threshold, the optimizer will consider using plans that will go parallel.

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.

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