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