Hello, just wanted to add my two cents, now that the Canadian is worth more and has been for longer than most have expected 🙂

Please don't use nolock on tables that have text/ntext/image data types, it causes excessive cpu useage according to Idera's tools, plus gives 7105 errors frequently in sql server logs, which cannot be good for any instance in production.

Huggy Bear, Huggy ji, Pugo, Huge...token mcdba since 2001.