I have a table used for reporting that gets rebuilt every half hour, a process which only takes 10 seconds. All my reports use SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED but still get hung if the rebuild occurs while they are using that table. Is there a hint I can use in the rebuild script to tell it to wait until there are zero locks of any kind on the table before it truncates and inserts? Or does that not matter because using READ UNCOMMITTED will not even put shared locks on the table?
Sorry if this has been answered in other posts and my searching skills are poor.