| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Table/Data Size Reporter v2.1 | SQL Server 7.0, Other | Beginner /
MisterD88 | 5785 since
10/5/2001 8:02:17 PM |
By 8 Users
8 Excellent Ratings
|
| |
Script to report table sizes (datatypes and data) for all user tables in the database executed on. Formatted to < 80 chars wide, should print nicely on any printer in portrait mode. Tested on SQL 7.0 & 2000 only, although it might work on 6.x as
well. ...(description truncated) |
| |
| |
| |
|
Tablespace Growth Monitoring | Oracle | Advanced /
Jony Safi | 6373 since
9/23/2003 5:06:20 PM | Unrated
|
| |
This query will show the tablespace occupation in an Oracle Database and this is very useful if made frequently. |
| |
| |
| |
|
 Validate SP's and UDF's with checksum | SQL Server 2000 | Intermediate /
Joseph Gama | 4534 since
5/10/2003 11:06:15 AM | Unrated
|
| |
Validate SP's and UDF's with checksum
This UDF will return the checksum for a SP or UDF to help tracking changes to the code.<BR>Example:<BR>print dbo.OBchecksum('hello')
|
| |
Please support the site by visiting our
sponsor:
|
| |
| |
|
Watch a DB Size or its user tables | SQL Server 2000, SQL Server 7.0 | Advanced /
marisol gonzalez | 5150 since
2/26/2004 12:47:53 PM |
By 1 Users
|
| |
Displays the number of rows, disk space reserved, and disk space used by a table in the current database, or displays the disk space reserved and used by the entire database. Defitnition from BOL, but my sp show all tables for a current DB while sp_spaceu ...(description truncated) |
| |
| |
| |
|
Who starts a blocking "chain" | SQL Server 7.0 | Intermediate /
Mario Estrada | 4383 since
4/28/2001 11:23:11 AM |
By 3 Users
3 Excellent Ratings
|
| |
Obtains the SPID that starts a blocking chain |
| |
