Tech Coast Designs, Inc.

     714-454-6401

 

You may find the following TSQL scripts to be helpful with SQL Server development.

 

SpaceUsed_sp.sql This stored procedure shows the space used by each table in the database, sorted by size in descending order.  It is useful for isolating problems with a database that is becoming large and unwieldy.
Cursor.sql This is a generic cursor script that can be readily insert into a stored procedure or executed stand alone.