This is a bit of an embarrassing question, and I can't believe I've missed this for so many years.
I have a vendor third-party database that has 401 heap tables. I've recently got into using Brent Ozar's scripts and setup
sp_BlitzFirst to run every 15 minutes to gather wait stats, etc.
What it uncovered was every time it ran across a 24 hour period it was telling me to fix Forwarded Records. What will probably shock some readers that I ran a query across the DMVs and got back some tables with over 150,000 forwarded record values.
I understand to fix this is to have a clustered index across the table, or as a temporary work-around to run
ALTER TABLE [tablename] REBUILD.
What I haven't been able to find however is whether this takes the table offline, and whether there are any other problems I should be aware of before running this command.
I am using the Enterprise Edition of 2008 R2, and I wonder whether running it this way will remove the need for an outage?
ALTER TABLE [tablename] REBUILD WITH (ONLINE = ON);
Does anyone have any experience with this?