mike 57299 (10/29/2012)
I tried to change a table from char(xx) to varchar(xx). It seems that it doubled the amount of space used. What gives?
Rebuild the clustered index, the table should drop back down (providing those char columns you changed weren't something like char(2))
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability