|
Posted by Dan Guzman on 05/23/05 16:29
You can reorg the table by rebuilding the table's clustered index.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"wriggs" <ian.w@btinternet.com> wrote in message
news:1116844882.254733.254670@g47g2000cwa.googlegroups.com...
> Hi,
>
> This is probably an easy question for someone so any help would be
> appreciated.
>
> I have changed the columns in a table that where nvarchar to the same
> size of type varchar so halve the space needed for them.
>
> I have done this a) becuase this is never going to be an international
> application, b) we are running out of space and c) there are 100
> million rows.
>
> I have done this with the alter table statement which seems to work but
> the space used in the database hasn't altered.
>
> I'm presuming that the way the records are structured within the table
> there is just now more space free inbetween each page???
>
> Is there a way or re-shrinking just an individual table and free up
> some of the space in there or am i missing the point somewhere?
>
> Thanks in advance,
>
> Ian
>
Navigation:
[Reply to this message]
|