Defect List Index

QCAR	6	Cartesian product	Performance
QFIB	6	Force index with bad index	Performance
QBGB	6	Bad group by	Misc
MBPA	6	Not a parameter of this proc	Misc
QTJ2	6	Table only appears in outer join clause	Misc
MTDS	6	Too Many Database Switches	Misc
MURC	6	Unreachable Code	Misc
MPTW	6	Param passed by name twice	Variable
VNDC	6	Variable is not declared	Variable
PERR	6	Parsing Error	Regular
QJWI	5	Join or Sarg Without Index	Performance
MRIT	5	Return in Transaction	Misc
QIMO	5	Table is inner member of outer join and regular member of join at the same level	Misc
MUTS	5	Update of Timestamp column	Misc
QCAS	4	Cartesian product with single row	Performance
QTYP	4	Comparison type mismatch	Performance
QCSC	4	Costly 'select count()', use 'exists()'	Performance
QPUI	4	Join or Sarg with Un-Rooted Partial Index Use	Performance
QPR1	4	Potential Recompilation: index creation after access to table	Performance
QHNU	4	Unbalanced Optimizer Hint	Performance
QFPU	4	Unclosed Force plan	Performance
MTYP	4	Assignment type mismatch	Misc
MBRV	4	Bad return value [-1-99]	Misc
MCTR	4	Conditional Begin Tran or Commit Tran	Misc
MCPC	4	Copy Paste Code	Misc
MEST	4	Empty String will be replaced by Single Space	Misc
QFIN	4	Force index through index number	Misc
MMCN	4	Potentially Misleading Column Naming	Misc
TNOI	4	Table with no index	Misc
TNOU	4	Table with no unique index	Misc
MUTT	4	Unbalanced Temp Table Creation/Drop	Misc
MINU	4	Unique Index with nullable columns	Misc
MUSP	4	Unquoted String Parameter	Misc
MURP	4	Unrecognized pragma	Misc
QUDW	4	Update or delete with no where clause	Misc
MULT	4	Using literal database 'tempdb'	Misc
Q121	4	V12 Compat #1: Having containing outer join	Misc
Q122	4	V12 Compat #2: Correlated subquery with outer join	Misc
Q123	4	V12 Compat #3: Conjunct with inner table and join order independent table	Misc
VOVR	4	Variable is an input param and is overwritten	Variable
VUWR	4	Variable is an output param and is not written to	Variable
VRUN	4	Variable is read and not initialized	Variable
QDIS	3	Check correct use of 'select distinct'	Performance
QUNI	3	Check Use of 'union' vs 'union all'	Performance
QFAP	3	Force abstract plan	Performance
QFID	3	Force index	Performance
QFPL	3	Force plan	Performance
QMTB	3	From clause with many tables	Performance
QJWT	3	Join or Sarg Without Index on temp table	Performance
QPRI	3	Join or Sarg with Rooted Partial Index Use	Performance
QHNT	3	Optimizer Hint	Performance
QSWV	3	Sarg with variable	Performance
QISO	3	Set isolation level	Performance
QTLO	3	Top-Level OR	Performance
MNEJ	3	'Not Equal' join	Misc
QAPT	3	Access to Proxy Table	Misc
MAW1	3	Ad hoc Warning 1	Misc
MAW2	3	Ad hoc Warning 2	Misc
MAW3	3	Ad hoc Warning 3	Misc
MAW4	3	Ad hoc Warning 4	Misc
MAW5	3	Ad hoc Warning 5	Misc
MAW6	3	Ad hoc Warning 6	Misc
MAW7	3	Ad hoc Warning 7	Misc
MAW8	3	Ad hoc Warning 8	Misc
MAW9	3	Ad hoc Warning 9	Misc
MLCH	3	Char type with length>30	Misc
MUIN	3	Column created using implicit nullability	Misc
QCRS	3	Conditional Result Set	Misc
QCTC	3	Conditional Table Creation	Misc
CUNU	3	Cursor not updated: cursor should contain 'for read only' clause	Misc
CUUP	3	Cursor updated: cursor should contain 'for update' clause	Misc
CUSU	3	Cursor updated through 'searched update': risk of halloween rows	Misc
MGTP	3	Grant to public	Misc
QGWO	3	Group by/Distinct/Union without order by	Misc
MIIO	3	Index overlap	Misc
QIWC	3	Insert with not all columns specified	Misc
MBLI	3	Integer Value of Binary Literal is Platform Dependant	Misc
QPSC	3	Join on same column	Misc
NCER	3	Naming Convention Error	Misc
QPNC	3	No column in condition	Misc
QNCO	3	No column in result set	Misc
MNER	3	No Error Check	Misc
MNAC	3	Not using ANSI 'is null'	Misc
QNAJ	3	Not using ANSI Inner Join	Misc
QNAO	3	Not using ANSI Outer Join	Misc
QONC	3	On clause does not refer introduced table	Misc
MDYN	3	Proc uses Dynamic SQL but is not flagged with Dynamic Ownership Chain	Misc
QRPR	3	Repeated predicate	Misc
QNAM	3	Select expression has no name	Misc
QNUA	3	Should use Alias:	Misc
QTJ1	3	Table only appears in inner join clause	Misc
MUBC	3	Unbalanced begin tran/commit tran	Misc
MUPK	3	Update column which is part of a PK or unique index	Misc
CSBI	3	Updated Cursor should contain insensitive clause	Misc
MUUF	3	Update or Delete with Useless From Clause	Misc
MUOT	3	Updates outside transaction	Misc
MUTI	3	Update temptable with identity - 12.5.4 Regression	Misc
MUCO	3	Useless Code	Misc
QAFM	3	Var Assignment from potentially many rows	Misc
MZMB	3	Zombie: use of non-existent object	Misc
VNRD	3	Variable is not read	Variable
VUNU	3	Variable is not used	Variable
MSUC	2	Correlated Subquery Marker	Misc
MCWR	2	Create Proc With Recompile Marker	Misc
MDRV	2	Derived Table Marker	Misc
MDYE	2	Dynamic Exec Marker	Misc
MDYS	2	Dynamic SQL Marker	Misc
MEWR	2	Exec With Recompile Marker	Misc
CRDO	2	Read Only Cursor Marker	Misc
MRST	2	Result Set Marker	Misc
MSTT	2	Shared Temptable Marker	Misc
MSUB	2	Subquery Marker	Misc
CUPD	2	Updatable Cursor Marker	Misc
MSTA	2	Use of Star Marker	Misc
MTR1	2	Metrics: Comments Ratio	Metrics
MTR2	2	Metrics: Cyclomatic Complexity	Metrics
MTR3	2	Metrics: Query Complexity	Metrics