SQL server 2008 – correct way to rebuild a HEAP

Oopps! Upgrade your browser pretty please. Oopps! Upgrade your browser pretty please.

To rebuild a HEAP In previous versions of SQL server you had to create a clustered index and then drop the clustered index. That is not an optimal solution and Microsoft have finally added support for rebuilding a HEAP. The syntax is ALTER TABLE yourTableName REBUILD Feel free to contact us if you need help from one of our SQL server consultants.