SQL Server 2008 - big increase in size of the table [closed]

Closed. This question is off-topic. It is not currently accepting answers.

---

Want to improve this question? Update the question so it's on-topic for Stack Overflow.

Closed 11 years ago.

Improve this question

One year ago table contained 31 million rows, now contains 36 million rows, a table size is increased from 9 GB to 45 GB. The table contains 40 columns of type varchar (30) and one varchar(255), the total size of about 1500 bytes. Recovery mode is simple, and the log is of normal size. A year ago the DB was moved to SQL Server 2005 from SQL Server 2008开发者_如何学运维. What could have caused such a big increase in table size? Thank you

---

I'm assuming you're looking at size of the table in SSMS and it differentiates between data size (data stored in the table) and index size (data stored in non-clustered indexes).

• Longer strings in your VARCHAR(N) fields
• New columns
• New indexes
• Turned off compression

---

• Do have a clustered index?
• Index maintenance is running on new server?