# Rules listed by namespace
  
  
## Design
  
| Rule Id | Friendly Name | Ignorable | Description | Example? |
|----|----|----|----|----|
| [SRD0001](Design/SRD0001.md) | Missing natural key |   | Table does not have a natural key. |   |
| [SRD0002](Design/SRD0002.md) | Missing primary key |   | Table does not have a primary key. | Yes |
| [SRD0003](Design/SRD0003.md) | Avoid wide primary keys |   | Primary Keys should avoid using GUIDS or wide VARCHAR columns. |   |
| [SRD0004](Design/SRD0004.md) | Index on Foreign Key |   | Columns on both sides of a foreign key should be indexed. | Yes |
| [SRD0005](Design/SRD0005.md) | Avoid long CHAR types | Yes | Avoid the (n)char column type except for short static length data. |   |
| [SRD0006](Design/SRD0006.md) | Avoid SELECT * | Yes | Avoid using SELECT *. | Yes |
| [SRD0009](Design/SRD0009.md) | Non-transactional body |   | Wrap multiple action statements within a transaction. | Yes |
| [SRD0011](Design/SRD0011.md) | Equality Compare With NULL Rule |   | Equality and inequality comparisons involving a NULL constant found. Use IS NULL or IS NOT NULL. | Yes |
| [SRD0012](Design/SRD0012.md) | Unused variable |   | Variable declared but never referenced or assigned. | Yes |
| [SRD0013](Design/SRD0013.md) | Expected error handeling |   | Wrap multiple action statements within a try catch. | Yes |
| [SRD0014](Design/SRD0014.md) | TOP without an ORDER BY |   | TOP clause used in a query without an ORDER BY clause. | Yes |
| [SRD0015](Design/SRD0015.md) | Implicit column list |   | Always use a column list in INSERT statements. | Yes |
| [SRD0016](Design/SRD0016.md) | Unused input parameter | Yes | Input parameter never used. Consider removing the parameter or using it. | Yes |
| [SRD0017](Design/SRD0017.md) | Avoid Deletes Without Where Rule | Yes | DELETE statement without row limiting conditions. |   |
| [SRD0018](Design/SRD0018.md) | Unbounded UPDATE | Yes | UPDATE statement without row limiting conditions. |   |
| [SRD0019](Design/SRD0019.md) | Avoid joining tables with views | Yes | Avoid joining tables with views. |   |
| [SRD0020](Design/SRD0020.md) | Incomplete or missing JOIN predicate |   | The query has issues with the join clause. It is either missing a backing foreign key or the join is missing one or more columns. |   |
| [SRD0021](Design/SRD0021.md) | Consider EXISTS Instead Of In Rule | Yes | Consider using EXISTS instead of IN when used with a subquery. |   |
| [SRD0024](Design/SRD0024.md) | Avoid EXEC or EXECUTE | Yes | Avoid EXEC and EXECUTE with string literals. Use parameterized sp_executesql instead. | Yes |
| [SRD0025](Design/SRD0025.md) | Avoid ORDER BY with numbers | Yes | Avoid using column numbers in ORDER BY clause. | Yes |
| [SRD0026](Design/SRD0026.md) | Unspecified type length |   | Do not use these data types (VARCHAR, NVARCHAR, CHAR, NCHAR) without specifying length. |   |
| [SRD0027](Design/SRD0027.md) | Unspecified precision or scale  |   | Do not use DECIMAL or NUMERIC data types without specifying precision and scale. |   |
| [SRD0028](Design/SRD0028.md) | Consider Column Prefix Rule | Yes | Consider prefixing column names with table name or table alias. |   |
| [SRD0030](Design/SRD0030.md) | Avoid Use of HINTS | Yes | Avoid using Hints to force a particular behavior. | Yes |
| [SRD0031](Design/SRD0031.md) | Avoid using CHARINDEX | Yes | Avoid using CHARINDEX function in WHERE clauses. |   |
| [SRD0032](Design/SRD0032.md) | Avoid use of OR in where clause | Yes | Try to avoid the OR operator in query where clauses if possible.  (Sargable) |   |
| [SRD0033](Design/SRD0033.md) | Avoid Cursors | Yes | Avoid using cursors. |   |
| [SRD0034](Design/SRD0034.md) | Use of NOLOCK |   | Do not use the NOLOCK clause. | Yes |
| [SRD0035](Design/SRD0035.md) | Forced delay |   | Do not use WAITFOR DELAY/TIME statement in stored procedures, functions, and triggers. |   |
| [SRD0036](Design/SRD0036.md) | Do not use SET ROWCOUNT | Yes | Do not use SET ROWCOUNT to restrict the number of rows. |   |
| [SRD0038](Design/SRD0038.md) | Alias Tables Rule | Yes | Consider aliasing all table sources in the query. | Yes |
| [SRD0039](Design/SRD0039.md) | Object not schema qualified |   | Use fully qualified object names in SELECT, UPDATE, DELETE, MERGE and EXECUTE statements. [schema].[name]. | Yes |
| [SRD0041](Design/SRD0041.md) | Avoid SELECT INTO temp or table variables | Yes | Avoid use of the SELECT INTO syntax. |   |
| [SRD0043](Design/SRD0043.md) | Possible side-effects implicit cast  |   | The arguments of the function '{0}' are not of the same datatype. |   |
| [SRD0044](Design/SRD0044.md) | Error handling requires SA permissions |   | The RAISERROR statement with severity above 18 requires the WITH LOG clause. |   |
| [SRD0045](Design/SRD0045.md) | Excessive indexes on table |   | Excessive number of indexes on table found on table. |   |
| [SRD0046](Design/SRD0046.md) | Use of approximate data type |   | Do not use the real or float data types for parameters or columns as they are approximate value data types. |   |
| [SRD0047](Design/SRD0047.md) | Ambiguous column name across design | Yes | Avoid using columns that match other columns by name, but are different in type or size. |   |
| [SRD0050](Design/SRD0050.md) | Expression reducible to constaint | Yes | The comparison expression always evaluates to TRUE or FALSE. | Yes |
| [SRD0051](Design/SRD0051.md) | Do Not Use Deprecated Types Rule | Yes | Don't use deprecated TEXT, NTEXT and IMAGE data types. | Yes |
| [SRD0052](Design/SRD0052.md) | Duplicate/Overlapping Index |   | Index has exact duplicate or borderline overlapping index. |   |
| [SRD0053](Design/SRD0053.md) | Explicit collation other | Yes | Object has different collation than the rest of the database. Try to avoid using a different collation unless by design. |   |
| [SRD0055](Design/SRD0055.md) | Object level option override |   | The object was created with invalid options. |   |
| [SRD0056](Design/SRD0056.md) | Unsafe identity retrieval | Yes | Use OUTPUT or SCOPE_IDENTITY() instead of @@IDENTITY. |   |
| [SRD0057](Design/SRD0057.md) | Do Not Mix DML With DDL Rule | Yes | Do not mix DML with DDL statements. Group DDL statements at the beginning of procedures followed by DML statements. |   |
| [SRD0058](Design/SRD0058.md) | Ordinal parameters used |   | Always use parameter names when calling stored procedures. |   |
| [SRD0060](Design/SRD0060.md) | Permission change in stored procedure |   | The procedure grants itself permissions. Possible missing GO command. | Yes |
| [SRD0061](Design/SRD0061.md) | Invalid database configured options |   | The database is configured with invalid options. |   |
| [SRD0062](Design/SRD0062.md) | Implicit collation |   | Create SQL Server temporary tables with the correct collation or use database default as the tempdb having a different collation than the database can cause issues and or data instability. |   |
| [SRD0063](Design/SRD0063.md) | Avoid wrapping SQL in IF statement | Yes | Do not use IF statements containing queries in stored procedures. | Yes |
| [SRD0064](Design/SRD0064.md) | Consider Caching Get Date To Variable | Yes | Cache multiple calls to GETDATE or SYSDATETIME into a variable. |   |
| [SRD0065](Design/SRD0065.md) | Avoid NOT FOR REPLICATION |   | Avoid 'NOT FOR REPLICATION' unless this is the desired behavior and replication is in use. |   |
| [SRD0066](Design/SRD0066.md) | BEGIN and END symbols inside conditional statements. | Yes | Use BEGIN and END symbols inside conditional statements. | Yes |
| [SRD0067](Design/SRD0067.md) | Use capitalized keywords for enhanced readability. |   | Use capitalized keywords for enhanced readability. | Yes |
| [SRD0068](Design/SRD0068.md) | Terminate statements with semicolon. | Yes | Query statements should finish with a semicolon - ';'. | Yes |
| [SRD0069](Design/SRD0069.md) | Xact_Abort On | Yes | Use SET XACT_ABORT ON in stored procedures with explicit transactions. | Yes |
| [SRD0071](Design/SRD0071.md) | CASE without ELSE | Yes | CASE expression should include an ELSE clause. | Yes |
| [SRD0072](Design/SRD0072.md) | Variable self-assignment | Yes | Variable should not be assigned to itself. | Yes |
| [SRD0073](Design/SRD0073.md) | Repeated NOT operator | Yes | Repeated NOT operators found. Simplify the expression. | Yes |
| [SRD0074](Design/SRD0074.md) | Weak hashing algorithm | Yes | Avoid weak hashing algorithms (MD2, MD4, MD5, SHA, SHA1). Use SHA2_256 or SHA2_512. | Yes |
| [SRD0075](Design/SRD0075.md) | Hard-coded credentials | Yes | Avoid hard-coded credentials. Use secure configuration instead. | Yes |
| [SRD0076](Design/SRD0076.md) | Identical expressions on both sides | Yes | Identical expressions on both sides of a comparison operator. | Yes |
| [SRD0077](Design/SRD0077.md) | FETCH variable count mismatch | Yes | FETCH variable count does not match cursor column count. | Yes |
| [SRD0078](Design/SRD0078.md) | Single character alias | Yes | Single character aliases are poor practice. | Yes |
| [SRD0079](Design/SRD0079.md) | Single character variable | Yes | Single character variable names are poor practice. | Yes |
| [SRD0080](Design/SRD0080.md) | TOP expression should use parentheses | Yes | Expression used with TOP should be wrapped in parentheses. | Yes |
| [SRD0081](Design/SRD0081.md) | TOP(100) PERCENT ignored by optimizer |   | TOP(100) PERCENT is ignored by the optimizer. | Yes |
| [SRD0082](Design/SRD0082.md) | Do not change DATEFORMAT | Yes | Changing DATEFORMAT can cause date parsing issues. | Yes |
| [SRD0083](Design/SRD0083.md) | Avoid changing DATEFIRST | Yes | Do not change DATEFIRST. | Yes |
| [SRD0084](Design/SRD0084.md) | Concat Null Yields Null ON | Yes | SET CONCAT_NULL_YIELDS_NULL should be ON. | Yes |
| [SRD0085](Design/SRD0085.md) | ANSI_NULLS should be ON | Yes | ANSI_NULLS should be ON. | Yes |
| [SRD0086](Design/SRD0086.md) | ANSI_PADDING should be ON | Yes | ANSI_PADDING should be ON. | Yes |
| [SRD0087](Design/SRD0087.md) | ANSI_WARNINGS should be ON | Yes | ANSI_WARNINGS should be ON. | Yes |
| [SRD0088](Design/SRD0088.md) | NUMERIC_ROUNDABORT should be OFF | Yes | NUMERIC_ROUNDABORT should be OFF - Required for indexed views. | Yes |
| [SRD0089](Design/SRD0089.md) | Quoted identifier on | Yes | QUOTED_IDENTIFIER should be ON - Required for indexed views and filtered indexes. | Yes |
| [SRD0090](Design/SRD0090.md) | SET FORCEPLAN should be OFF | Yes | SET FORCEPLAN should be OFF. | Yes |
| [SRD0091](Design/SRD0091.md) | Avoid ORDER BY in derived tables for final ordering |   | Ordering in a derived table does not guarantee result set ordering. | Yes |
| [SRD0092](Design/SRD0092.md) | Avoid named primary key constraints on temp tables | Yes | Primary Key Constraints on temporary tables should not be named. | Yes |
| [SRD0093](Design/SRD0093.md) | Do not name default constraints on temporary tables |   | Default constraints on temporary tables should not be named. | Yes |
| [SRD0094](Design/SRD0094.md) | Avoid named foreign keys on temporary tables | Yes | Foreign key constraints on temp tables should not be named. |   |
| [SRD0095](Design/SRD0095.md) | Named check constraints on temp tables | Yes | Check constraints on temp tables should not be named. | Yes |
| [SRD0096](Design/SRD0096.md) | Potential SQL injection issue |   | Potential SQL injection issue. | Yes |
| [SRD0700](Design/SRD0700.md) | Database PAGE_VERIFY option is not CHECKSUM |   | Set `<PageVerify>CHECKSUM</PageVerify>` in the project file to enable PAGE_VERIFY = CHECKSUM. (Use `<PageVerifyMode>Checksum</PageVerifyMode>` for MSBuild.Sdk.SqlProj projects.) |   |
| [SRD0701](Design/SRD0701.md) | Database QUERY_STORE option is not READ_WRITE |   | Set `<QueryStoreDesiredState>READ_WRITE</QueryStoreDesiredState>` in the project file to enable Query Store. (Use `<QueryStoreDesiredState>ReadWrite</QueryStoreDesiredState>` for MSBuild.Sdk.SqlProj projects.) |   |
| [SRD0703](Design/SRD0703.md) | Database QUERY_STORE_CAPTURE_MODE option is not AUTO |   | Set `<QueryStoreCaptureMode>AUTO</QueryStoreCaptureMode>` in the project file to enable QUERY_STORE_CAPTURE_MODE = AUTO. |   |
| [SRD0704](Design/SRD0704.md) | Database TARGET_RECOVERY_TIME option is not set |   | Set `<TargetRecoveryTimePeriod>60</TargetRecoveryTimePeriod>` in the project file to enable TARGET_RECOVERY_TIME. |   |
| [SRD0705](Design/SRD0705.md) | Database AUTO_CLOSE option is not OFF |   | Set `<AutoClose>False</AutoClose>` in the project file to disable AUTO_CLOSE. |   |
| [SRD0706](Design/SRD0706.md) | Database AUTO_SHRINK option is ON |   | Set `<AutoShrink>False</AutoShrink>` in the project file to disable AUTO_SHRINK. |   |
  
## Naming
  
| Rule Id | Friendly Name | Ignorable | Description | Example? |
|----|----|----|----|----|
| [SRN0001](Naming/SRN0001.md) | UDF with System prefix | Yes | Avoid 'fn_' prefix when naming functions. |   |
| [SRN0002](Naming/SRN0002.md) | Procedure name may conflict system name | Yes | Avoid 'sp_' prefix when naming stored procedures. |   |
| [SRN0006](Naming/SRN0006.md) | Use of default schema |   | Two part naming on objects is required. | Yes |
| [SRN0007](Naming/SRN0007.md) | Name standard |   | General naming rules. | Yes |
  
## Performance
  
| Rule Id | Friendly Name | Ignorable | Description | Example? |
|----|----|----|----|----|
| [SRP0001](Performance/SRP0001.md) | Nested Views |   | Views should not use other views as a data source. |   |
| [SRP0002](Performance/SRP0002.md) | Unanchored string pattern | Yes | Try to avoid using patterns that start with '%' when using the LIKE keyword if possible.  (Sargable) |   |
| [SRP0003](Performance/SRP0003.md) | Aggregate of unique set | Yes | Avoid using DISTINCT keyword inside of aggregate functions. |   |
| [SRP0004](Performance/SRP0004.md) | Noisy trigger | Yes | Avoid returning results in triggers. |   |
| [SRP0005](Performance/SRP0005.md) | Noisy trigger | Yes | SET NOCOUNT ON is recommended to be enabled in stored procedures and triggers. | Yes |
| [SRP0006](Performance/SRP0006.md) | Use of inequality | Yes | Try to avoid using not equal operator (<>,!=) in the WHERE clause if possible. (Sargable) |   |
| [SRP0007](Performance/SRP0007.md) | Dangling cursor |   | Local cursor not closed. |   |
| [SRP0008](Performance/SRP0008.md) | Unfreed cursor |   | Local cursor not explicitly deallocated. |   |
| [SRP0009](Performance/SRP0009.md) | Filtering on calculated value | Yes | Avoid wrapping columns within a function in the WHERE clause. (Sargable) | Yes |
| [SRP0010](Performance/SRP0010.md) | Function in data modification | Yes | Avoid the use of user defined functions with UPDATE/INSERT/DELETE statements. (Halloween Protection) |   |
| [SRP0011](Performance/SRP0011.md) | Non-member test in predicate | Yes | Avoid using the NOT IN predicate in a WHERE clause. (Sargable) |   |
| [SRP0012](Performance/SRP0012.md) | Un-indexed membership test | Yes | Consider indexing the columns referenced by IN predicates in order to avoid table scans. |   |
| [SRP0013](Performance/SRP0013.md) | Existence tested with JOIN | Yes | Consider replacing the OUTER JOIN with EXISTS. | Yes |
| [SRP0014](Performance/SRP0014.md) | Table variable in JOIN | Yes | Avoid the use of table variables in join clauses. |   |
| [SRP0015](Performance/SRP0015.md) | Avoid Column Calculations | Yes | Avoid the use of calculations on columns in the where clause. (Sargable) |   |
| [SRP0016](Performance/SRP0016.md) | Equality test with mismatched types |   | Data types on both sides of an equality check should be the same in the where clause. (Sargable) | Yes |
| [SRP0017](Performance/SRP0017.md) | Update of Primary key | Yes | Avoid updating columns that are part of the primary key.  (Halloween Protection) |   |
| [SRP0018](Performance/SRP0018.md) | High join count |   | Query uses a high number of joins.  |   |
| [SRP0020](Performance/SRP0020.md) | Missing Clustered index |   | Table does not have a clustered index. | Yes |
| [SRP0021](Performance/SRP0021.md) | Manipulated parameter value | Yes | Avoid modification of parameters in a stored procedure prior to use in a select query. |   |
| [SRP0022](Performance/SRP0022.md) | Procedure level recompile option | Yes | Consider using RECOMPILE query hint instead of the WITH RECOMPILE option. | Yes |
| [SRP0023](Performance/SRP0023.md) | Enumerating for existence check | Yes | When checking for existence use EXISTS instead of COUNT | Yes |
| [SRP0024](Performance/SRP0024.md) | Correlated subquery | Yes | Avoid the use of correlated subqueries except for very small tables. |   |
| [SRP0025](Performance/SRP0025.md) | SELECT * in EXISTS | Yes | Use SELECT 1 instead of SELECT * in EXISTS subqueries. | Yes |
| [SRP0026](Performance/SRP0026.md) | Avoid cross-server joins | Yes | Avoid cross-server joins. | Yes |
| [SRP0027](Performance/SRP0027.md) | Avoid explicit conversion of columnar data | Yes | Avoid explicit conversion of columnar data in the WHERE clause. (Sargable) | Yes |
| [SRP0028](Performance/SRP0028.md) | Explicit RANGE window frame | Yes | Avoid explicit RANGE window frames; prefer explicit ROWS. | Yes |
| [SRP0029](Performance/SRP0029.md) | Implicit RANGE window frame | Yes | Specify a window frame explicitly for window functions with ORDER BY to avoid implicit RANGE semantics. | Yes |
| [SRP0030](Performance/SRP0030.md) | Specify FAST_FORWARD for cursors | Yes | Cursors default to writable. Specify FAST_FORWARD. | Yes |
  
## Microsoft 
  
| Rule Id | Friendly Name | Ignorable | Description | Example? |
|----|----|----|----|----|
| [SR0001 Design ](https://learn.microsoft.com/sql/tools/sql-database-projects/concepts/sql-code-analysis/t-sql-design-issues#sr0001-avoid-select--in-stored-procedures-views-and-table-valued-functions) | Avoid SELECT * in stored procedures, views, and table-valued functions |  | Avoid SELECT * in stored procedures, views, and table-valued functions | Yes |
| [SR0008 Design ](https://learn.microsoft.com/sql/tools/sql-database-projects/concepts/sql-code-analysis/t-sql-design-issues#sr0008-consider-using-scope_identity-instead-of-identity) | Consider using SCOPE_IDENTITY instead of @@IDENTITY |  | Consider using SCOPE_IDENTITY instead of @@IDENTITY | Yes |
| [SR0009 Design ](https://learn.microsoft.com/sql/tools/sql-database-projects/concepts/sql-code-analysis/t-sql-design-issues#sr0009-avoid-using-types-of-variable-length-that-are-size-1-or-2) | Avoid using types of variable length that are size 1 or 2 |  | Avoid using types of variable length that are size 1 or 2 | Yes |
| [SR0010 Design ](https://learn.microsoft.com/sql/tools/sql-database-projects/concepts/sql-code-analysis/t-sql-design-issues#sr0010-avoid-using-deprecated-syntax-when-you-join-tables-or-views) | Avoid using deprecated syntax when you join tables or views |  | Avoid using deprecated syntax when you join tables or views | Yes |
| [SR0013 Design ](https://learn.microsoft.com/sql/tools/sql-database-projects/concepts/sql-code-analysis/t-sql-design-issues#sr0013-output-parameter-parameter-isnt-populated-in-all-code-paths) | Output parameter (parameter) isn't populated in all code paths |  | Output parameter (parameter) isn't populated in all code paths | Yes |
| [SR0014 Design ](https://learn.microsoft.com/sql/tools/sql-database-projects/concepts/sql-code-analysis/t-sql-design-issues#sr0014-data-loss-might-occur-when-casting-from-type1-to-type2) | Data loss might occur when casting from {Type1} to {Type2} |  | Data loss might occur when casting from {Type1} to {Type2} | Yes |
| [SR0011 Naming ](https://learn.microsoft.com/sql/tools/sql-database-projects/concepts/sql-code-analysis/t-sql-naming-issues#sr0011-avoid-using-special-characters-in-object-names) | Avoid using special characters in object names |  | Avoid using special characters in object names | Yes |
| [SR0012 Naming ](https://learn.microsoft.com/sql/tools/sql-database-projects/concepts/sql-code-analysis/t-sql-naming-issues#sr0012-avoid-using-reserved-words-for-type-names) | Avoid using reserved words for type names |  | Avoid using reserved words for type names | Yes |
| [SR0016 Naming ](https://learn.microsoft.com/sql/tools/sql-database-projects/concepts/sql-code-analysis/t-sql-naming-issues#sr0016-avoid-using-sp_-as-a-prefix-for-stored-procedures) | Avoid using sp_ as a prefix for stored procedures |  | Avoid using sp_ as a prefix for stored procedures | Yes |
| [SR0004 Performance ](https://learn.microsoft.com/sql/tools/sql-database-projects/concepts/sql-code-analysis/t-sql-performance-issues#sr0004-avoid-using-columns-that-dont-have-indexes-as-test-expressions-in-in-predicates) | Avoid using columns that don't have indexes as test expressions in IN predicates |  | Avoid using columns that don't have indexes as test expressions in IN predicates | Yes |
| [SR0005 Performance ](https://learn.microsoft.com/sql/tools/sql-database-projects/concepts/sql-code-analysis/t-sql-performance-issues#sr0005-avoid-using-patterns-that-start-with--in-like-predicates) | Avoid using patterns that start with "%" in LIKE predicates |  | Avoid using patterns that start with "%" in LIKE predicates | Yes |
| [SR0006 Performance ](https://learn.microsoft.com/sql/tools/sql-database-projects/concepts/sql-code-analysis/t-sql-performance-issues#sr0006-move-a-column-reference-to-one-side-of-a-comparison-operator-to-use-a-column-index) | Move a column reference to one side of a comparison operator to use a column index |  | Move a column reference to one side of a comparison operator to use a column index | Yes |
| [SR0007 Performance ](https://learn.microsoft.com/sql/tools/sql-database-projects/concepts/sql-code-analysis/t-sql-performance-issues#sr0007-use-isnullcolumn-default_value-on-nullable-columns-in-expressions) | Use ISNULL(column, default_value) on nullable columns in expressions |  | Use ISNULL(column, default_value) on nullable columns in expressions | Yes |
| [SR0015 Performance ](https://learn.microsoft.com/sql/tools/sql-database-projects/concepts/sql-code-analysis/t-sql-performance-issues#sr0015-extract-deterministic-function-calls-from-where-predicates) | Extract deterministic function calls from WHERE predicates |  | Extract deterministic function calls from WHERE predicates | Yes |
  
<sub><sup>Generated by a tool</sup></sub>