Subject: RE: Just found the glossary!To always SELECT * FROM whatever WITH (NOLOCK) is potentially rude, criminal, immoral or even dangerous. For instance
SET @TenCommandments4SQLGeeks = SELECT REPLACE ( 10 Commandments , 'covet' , 'SELECT xxx WITH (NOLOCK)' ) It's usually best to assess the situation first. ![Laughing Laughing](../tinymce/plugins/emotions/images/smiley-laughing.gif) |