| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Shrink l og | SQL Server 2000 | Beginner /
Ebenezer Barnes | 5721 since
7/31/2006 2:10:31 AM |
By 3 Users
2 Excellent Ratings
|
| |
The purpose of this script is to shrink the log file of a database to 1MB.
The log file of most large databases consume a large amount of disk space.
On a file server where space is very crucial, this can present significant
headache for administrators.
...(description truncated) |
| |
| |
| |
|
 Shrink Log files immediately | SQL Server 7.0 | Intermediate /
David Albrecht | 11957 since
3/6/2002 9:50:22 PM |
By 1 Users
|
| |
A stored procedure to shrink SQL Log files on the fly. Simply paste the code as a new stored procedure in the database that requires shrinking. |
| |
| |
| |
|
sp_GetCharDataLengthAnalysis | SQL Server 7.0 | Intermediate /
Robert Vallee | 4759 since
8/10/2001 9:58:18 AM | Unrated
|
| |
Scan all your character based columns and review the minimum, maximum, average length of data stored in that column. As well as the efficiency rating for that column. |
| |
Please support the site by visiting our
sponsor:
|
| |
| |
|
Space per table | SQL Server 7.0 | Advanced /
Mario Estrada | 7335 since
4/23/2001 10:00:18 PM |
By 6 Users
5 Excellent Ratings
|
| |
Get space used by each table on you database (size in rows and KB) |
| |
| |
| |
|
Table/Data size reporter | SQL Server 7.0, Other | Beginner /
MisterD | 7437 since
6/28/2001 9:38:11 PM |
By 4 Users
2 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.
|
| |
