Sorry, hit send too quickly. NOLOCK is kinda like NOWAIT, except implies that the command will not take a strong lock instead of stating that it will not wait for one.
On Mon, 2006-07-24 at 11:20 -0400, Rod Taylor wrote: > > SHARED CREATE INDEX .... > > > Comments? > > CREATE [UNIQUE] INDEX <foo> [WITH NOLOCK] ON ... > > -- ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings