Create a SQL Server index without locking the table
If you have a large table of data in a SQL server database, and you want to add a new index, but can’t afford to lock the table, then this article will help you. However, please note: This does does actually lock the table still, but only briefly. This will not work with SQL Server