Depending on the locking scheme for the table (page or row level or whatever else MSSQL has), you shouldn't have to wait for the table, but may have to wait for the row or page.