Table Space Used in DB

A quick script that provides the sizes of the tables in your database, including schema and choice of sort method

Comparing Space Usage for Different Compression Types

This is an investigation, to get an impression on the impact of the used disk space before and after compression considering different index types.

A Better sp_Spaceused

Quick table size information

Uses a loop and sp_spaceused to populate a temp table with size info

The joy of sp_spaceused

This script uses a cursor to loop through all tables and get the count and table sizes using sp_spaceused. It is much faster and efficient than use 'SELECT COUNT(*) FROM TABLE_NAME'.

Space Used By Table

Small script I use to find tables that are running away with the space.

Monitor database growth - a better way for sp_spaceused

A better way to use sp_spaceused, returning values on one row for the database instead of two.

RE: Date Conversion

I run the sql statement through the DTS package--It is the "Execute SQL Task" icon within DTS.

RE: Help with hitting a wall

Just in case anyone still cares about this problem, it turned out to be a conflict with the SCSI cards and the scanners (believe it or not). Once a certain volume of data had passed through the SCSI card it just seemed to close itself down until the PC was reset...We had the latest SCSI […]

RE: Error trapping in TSQL

See. if this helps:http://www.sommarskog.se/error-handling-II.htmlhttp://www.sommarskog.se/error-handling-I.html