To rebuild a HEAP In previous versions of SQL server you had to create a…
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.