| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 check the free space in your database | Oracle | Advanced /
Andy Archer | 1550 since
12/25/2011 5:50:39 PM | Unrated
|
| |
This SQL*Plus script prompts for a PERCENT USED value, runs SQL to get data on all tablespaces with that percentage (or more) of used space, spools the results to a file, and opens the file in Notepad. |
| |
| |
| |
 |
 clear databse | SQL Server 2000 | Intermediate /
Pelena Dewage Chinthaka Nayomall | 5509 since
3/31/2008 2:47:38 PM | Unrated
|
| |
Thru This you can drop all objects in you database at once and you can clear your database |
| |
| |
| |
|
 Deleting Duplicate Rows | SQL Server 2000, SQL Server 7.0 | Advanced /
barkın ünüulu | 18378 since
11/20/2004 5:06:51 AM |
By 4 Users
|
| |
The Purpose of this code is to delete the duplicate values occuring in a table. This code is column-oriented. That means the code works for the duplicate values occuring in a specified column and deletes the values of the rows corresponding to that column ...(description truncated) |
| |
Please support the site by visiting our
sponsor:
|
| |
| |
|
Find and remove Dupes | SQL Server 7.0 | Advanced /
Lewis E. Moten III | 12588 since
2/8/2002 11:39:32 AM |
By 6 Users
3 Excellent Ratings
|
| |
Find and remove duplicate values within a table. |
| |
| |
| |
|
Get SQL Table Size - Table and Index Space - Row Count | SQL Server 2000, SQL Server 7.0 | Intermediate /
Zxtreme | 76756 since
7/30/2003 11:46:07 PM |
By 12 Users
8 Excellent Ratings
|
| |
This Script will return the row count and the amount of disk space that each table uses within a specifed database.
When returning total disk space used, it breaks it up into 3 categories...
1. The amount used by data
2. The Amount used by indexes
3. ...(description truncated) |
| |
| |
| |
|
GetTableSpace | SQL Server 2000 | Intermediate /
Igor Krupitsky | 10609 since
2/2/2006 12:03:05 AM |
By 3 Users
3 Excellent Ratings
|
| |
This stored procedure returns the list of tables with number of rows, data space used and index space used numbers. It is using an undocumented sp_Mstablespace stored procedure, which is a super fast alternative to select count(*) from TableName. |
| |
| |
| |
|
 Getting a row cound without doing a table scan. | SQL Server 2000 | Intermediate /
Andrew Novick | 9901 since
4/21/2003 10:18:46 AM |
By 3 Users
|
| |
Tells you how to go about getting a row count without doing a table scan. It explains some of the columsn of the sysindexes system table that are the source of the information and provides the code you need to obtain it easily. |
| |
| |
| |
|
Move tempdb | SQL Server 7.0 | Intermediate /
| 10834 since
2/15/2001 4:56:24 PM |
By 2 Users
2 Excellent Ratings
|
| |
Move the tempdb database in SQL Server 7. |
| |
| |
| |
|
Moving Schema's Across Tablespace's | Oracle | Intermediate /
jtanwar | 10690 since
2/27/2002 9:39:57 PM | Unrated
|
| |
If you are running a Number of Schemas Under One service(Which usually) the
Case is and Needs to Move all the Tables Belonging to a Particular schema’s
To a new tablespace, then instead of Manually typing the Command
Alter table tablename move tablesp ...(description truncated) |
| |
| |
| |
|
Shrink All User Database | SQL Server 7.0 | Intermediate /
L. F. Carpenter | 11346 since
6/13/2001 5:42:55 PM | Unrated
|
| |
This code will shrink all non-system databases |
| |
