Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Bloated table: how to fix
Message
 
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
01200148
Message ID:
01201015
Views:
26
>I figured it out. I was writing a few characters into every TEXT field instead of ''. The size dropped from 2.2 gigs to 40 megs. Whew!

Hi Evan,

In SQL 2005 it's better to use varchar(MAX) instead of text. If you have to use text, check http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/caveats-of-the-text-datatype.aspx
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform