Big SQL table. Is there a better way than ntext?

Question

Hi

I'm trying to fix a legacy system. It's a VB6 app on a SQL DB. They have a database table that's over a gig. It doesn't actually have a lot of rows. The reason is a lot of text in RTF format that is stored in an ntext field. Is there any way to reduce the size of the table without major surgery to the app?

Thanks a lot Mark

Answer 1

Have you looked with Management studio/Enterprise manager to the free space of that database? Maybe it has a lot of free space inside from older deleted data, or maybe the log has grown up too big and can be truncated.

Answer 2

What's broken? If it works, I'd say leave it. Otherwise describe the problem. A gig isn't by any means a prohibitive table size, esp. if there are few rows.