It might be trying to do a sort operation while you do that. What is your clustered index on?

it does seem pretty big - better than it was, but...

Yes - should have dropped that index from the temp table first

I also would agree that it looks to be a very efficient method of trending your database growth.

GSquared (1/22/2010)

---

There's a report you can get on schema changes. Deleting a table is a schema change.

Right-click on the database in Management Studio, and select Reports, then select Schema...

No

Here is a link with a doc to download that...

SQLPirate (1/22/2010)

---

Oops, yeah that's also a remnant from our environmental needs. The information in our current version also contains servernames,...

I would do that as a part of a manual process - or change them to always run every...

i took the liberty to update the script a little bit to allow better sorting based on different columns, such as Data.

By changing the Data column to a BigInt and...

SQLPirate (1/22/2010)

---

Using sp_mstablespace won't give you any unused space that the table is holding and sp_msforeachtable won't return internal tables. We were having issues pinpointing our space discrepancies, which were...

I second that vote.

rambilla4 (1/22/2010)

---

If I select the option Sort results in tempdb, the log size of 12GB of MyDB...

lmu92 (1/22/2010)

---

CirquedeSQLeil (1/22/2010)

---

For me there are a couple of points of interest. What is a fair and equitable split? Do you want the Client as a repeat client?...

For me there are a couple of points of interest. What is a fair and equitable split? Do you want the Client as a repeat client? If...

Here is an alternative script for Table Size in a database

-- Create the temp table for further querying

CREATE TABLE #temp(

rec_idint IDENTITY (1, 1),

table_namevarchar(128),

nbr_of_rowsint,

data_spacedecimal(15,2),

index_spacedecimal(15,2),

total_sizedecimal(15,2),

percent_of_dbdecimal(15,12),

db_sizedecimal(15,2))

-- Get all tables, names, and sizes

EXEC sp_msforeachtable...

LOL