CC101 Table without "WITH (NOLOCK)" hint used. CC101 <h2>Description</h2><p>Table without "WITH (NOLOCK)" hint used.</p><h2>Code examples</h2><h3>Non-compliant</h3><pre><code>SELECT DistributorID, FirstName, LastName From dbo.Distributor</code></pre><h3>Compliant</h3><pre><code>SELECT DistributorID, FirstName, LastName From dbo.Distributor WITH (NOLOCK)</code></pre> BLOCKER SINGLE LINEAR 2min Table_source_itemContext Select_statementContext Delete_statementContext Update_statementContext Merge_statementContext Insert_statementContext ClassOnly SkipIfNotFound Table_name_with_hintContext ClassOnly SkipIfNotFound Default Table_name_with_hintContext # TextAndClass SkipIfFound Contains SubqueryContext ClassOnly SkipIfFound Table_hintContext NOLOCK TextAndClass FailIfNotFound Contains Table without "WITH (NOLOCK)" hint used. ClassOnly Select DistributorID, FirstName, LastName From dbo.Distributor D Select DistributorID, FirstName, LastName From dbo.Distributor D WITH (NOLOCK)