Re: Actual Used space

Wayne Kidd wrote: > > Does anyone have a query for the SMI tables or any other > tables, that will return the actual used space of a table. > I am setting up a database copy function that will copy an > entire database ( several thousand tables ) and I do not > want it to use the source system current extent sizes, I > want it to use the actual size for the target system so I > have to determine what that is. Thanks in advance. OK, let me get this right: You want to calculate the actual size of the table? Like by taking the number of rows and multiplying by the size of the row? That should tell you the size of the tables, but then you need to figure out the size of the indexes too. (Same type of calculation I guess.) Anyone know of an easier way? Also, do you need to run update statistics? -Mikey