Table Access During Index Build

Q. As you’re building an index on a table, does SQL Server block access to that table?

A. SQL Server doesn’t block read access to the table you’re building an index on unless you’re building a clustered index. However, if someone tries to update the table’s data, SQL Server blocks the update—

Read More - Register for Free Membership