| | |
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 |
| |