Find all numbers in a string 6/23
This function finds all the numbers in a string.

Email Validation 6/16
This procedure returns 0 if invalid mail ID else 1.

Delete all duplicate records in a table 6/09
This script will delete all duplicate records in a table.

Identity Fields 6/02
This script allows the user to find which tables in MSSQL Server have Identity fields.

Hierarchial Loop III 5/20
This script displays all of the employees working under a particular employee in a string, separated by a '|' as delimiter.

Test SQL Connectivity 5/19
This script tests connectivity to SQL Server box from a client machine when there is no SQL Client.

Database Physical & Actual Size 5/12
Useful on Oracle 8.1.7 onwards or remove the dba_temp_files line & run for earlier versions.

Drop all user schema tables 5/01
Using cascade constraints you can drop all tables from user schema.

DEFAULT column values 4/30
To avoide ARC_Triggers creation, you can use DEFAULT column values.

How to compare NULL with NULL 4/30
This script will compare NULL with NULL, because NULL is not equal to NULL.

Backup in Noarchivelog in RMAN 4/28
This script will backup in noarchivelog using RMAN.

Measure the Buffercache Hit Ratio for User Wise 4/28
This script allows you to see the bufferhit ratio of all application users, when all application users are running on the server, so that you can measure individual performance.

View the process block chain (sp_who_blocks) 4/22
This procedure is an extension of sp_who2 that shows additional information about the block chain using CTE.

Bitwise Math and Masking Functions 4/21
This script performs bitwise math and masking operations on numbers.