T-SQL Analyzer

# SQL Server Rule: SRD0030 | | | |----|----| | Assembly | SqlServer.Rules | | Namespace | SqlServer.Rules.Design | | Class | AvoidHintsRule | ## Rule Information | | | |----|----| | Id | SRD0030 | | Friendly Name | Avoid Use of HINTS | | Category | Design | | Ignorable | true | | Applicable Types | Procedure | | | Scalar Function | | | Table Valued Function | | | View | ## Description Avoid using Hints to force a particular behavior. ## Summary Avoid the use of HINTS to enforce a particular behavior in your code. ### Examples ```sql CREATE PROCEDURE [dbo].[ForceScan] AS set nocount on Select col1 from dbo.TestTableSSDT with(forcescan); RETURN 0 -- SML044, SRD0030 ``` _{^{Generated by a tool}}