A script to calculate the size of a database?

[mjp483]

Does anyone have a script to calculate the size of a single table?

I want to calculate the table size before and after I transport it to another db.

Mike

 

[mjp483]

I meant to title this "A script to calculate the size of a table

 

[cfw2]

there is a stored procedure called sp_spaceused that can be used to calculate the size of the database,
like execute sp_spaceused

or to calculate the size of a single table,
like execute sp_spaceused 'table_name'

that should do the trick.

cfw2

 

[mjp483]

Thanks that works great.

One thing I notice, when I drop and recreate my table, insert ALL data from the source table, and then compare using sp_spaceused 'TableName' I see a difference in the data size returned from sp_spaceused.

The number of rows is the same....Is there a reason the data size would be different between source and destination immediately after I run my transport script?

Ex:

Source
data = 35016 KB
Destination
data = 35240 KB

 

[vongrunt]

Yes, copying is dynamic process - a bit more complex than equivalent to physical moving object from location A to B.

------
heisenbug: A bug that disappears or alters its behavior when one attempts to probe or isolate it
schroedinbug: A bug that doesn't appear until someone reads source code and realizes it never should have worked, at which point the program promptly stops working for everybody until fixed.
[ba