| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 add a foreign key constraint on the fly, referencing an in-use parent table | Oracle | Advanced /
Andy Archer | 4833 since
12/2/2008 4:08:06 PM | Unrated
|
| |
This SQL*Plus script executes a PL/SQL block to add a foreign key constraint, and provides for referencing a table on which DML is occurring. An opening is sought amidst ORA-00054 exceptions while looping EXECUTE IMMEDIATE to ALTER TABLE. |
| |
| |
| |
|
 Analyzer | Oracle | Intermediate /
Ron Santillano | 11479 since
4/26/2002 9:07:53 PM |
By 1 Users
|
| |
This procedure will Analyze & Estimate Statistics for all tables in the users schema. Only takes 3-10 minutes to run. It can easily be edited to Compute Statistics or specific number of rows in each table. |
| |
| |
| |
|
Auto generating Templates | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Umachandar | 19603 since
8/11/2000 12:10:23 PM |
By 5 Users
|
| |
generate INSERT, UPDATE & DELETE statement templates for a table |
| |
Please support the site by visiting our
sponsor:
|
| |
| |
|
Automate tasks with undocumented MS stored procedures | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Umachandar | 16443 since
8/11/2000 12:12:53 PM |
By 5 Users
3 Excellent Ratings
|
| |
This script contains examples that show how to automate certain interative tasks easily using undocumented MS stored procedures. The stored procedures shown can be used to loop through each database or each table in a database & perform certain commands. |
| |
| |
| |
|
Automate the transfer of standard logins from one server to another with the passwords | SQL Server 7.0 | Advanced /
Umachandar | 11122 since
7/23/2000 2:24:17 PM |
By 2 Users
|
| |
A script to automate the transfer of standard logins from one server to another with the passwords. This one uses a distributed query against the source server. |
| |
| |
| |
|
 Baan index performance, oxym0ron! | Informix
, Oracle | Beginner /
Steven Hauser | 8503 since
7/11/2000 11:04:57 PM | Unrated
|
| |
Baan Indexes - Anchor your Performance Firmly in the Mud. I do not know about you, but BaanIVc with the "Level 2" Oracle driver
has some of the worst indexes I have seen, well, since PeopleSoft anyway. And this is not just Oracle specific, any database wi ...(description truncated) |
| |
| |
| |
|
Backup All Databases | SQL Server 7.0, SQL Server 6.5 and earlier | Advanced /
PHendryx | 38989 since
3/23/2001 9:12:15 AM |
By 13 Users
9 Excellent Ratings
|
| |
This script was written because I have a server with about 115 client databases on it. It was a rather hard task to try to backup all of them by hand and I didnt want to spend a few grand on a good piece of backup software. Basicly, this script just loops ...(description truncated) |
| |
| |
| |
|
Build a Backup Strategy to MSDE | SQL Server 2000 | Advanced /
Jairo Abraham Bernal Villanueva | 7956 since
9/24/2006 9:56:59 AM |
By 2 Users
|
| |
This code permits to make a backup strategy using osql.
 (ScreenShot) |
| |
| |
| |
|
Change all table owners in a flash | SQL Server 7.0, Other | Intermediate /
James Travis | 15802 since
2/4/2002 6:44:38 AM |
By 6 Users
6 Excellent Ratings
|
| |
To quickly change the owner of all the tables in a database. |
| |
| |
| |
|
checking and repairing all databases in the server | SQL Server 7.0 | Intermediate /
Eli Leiba | 11226 since
11/1/2001 8:43:32 AM |
By 3 Users
|
| |
checking all DATABASE and repairing and rebuilding them for maintanance |
| |
(ScreenShot)
