Which ones? I know you can in SQL Server but not as cleanly as this. It's done transparently by PG.
> "In Oracle, readers never wait for writers or vice versa. I can serve my 18,000 daily users. I can EXPORT a consistent backup dump. I can update a 20,000 row table. I can rebuild an index. All simultaneously."
SQL Server looks pretty clean to me.
ALTER INDEX IX_name ON schema.table REBUILD WITH (ONLINE=ON);