I am familiar with setting and rebuilding indexes in SQL Server 2000, but I have been asked to investigate how to rebuild the data in a database.
We have a table that contains an large amount of data. Several new columns have been added to this table and my boss says I will need to rebuild the data as well as the indexes so that it is stored contiguously instead of being scattered all over the place.
I've had a look through books online and can only come up with references to rebuilding the master database.
Can anyone point me in the right direction?
Thanks for your time.
Windows 2008 Server | SQL Server 2008