Keyword(s) for which to search:
Sort results by title
Keyword Index
Getting started
What is SQL Enlight
Activating SQL Enlight
Deactivating SQL Enlight
Installing SQL Enlight
Check For Updates
Uninstalling SQL Enlight
Using SQL Enlight
Working with SQL Enlight
Validating and Formatting T-SQL Code
Performing Static Analysis
Manage Analysis Groups
Manage Analysis Rules
Managing Layout Templates
Managing Settings
Outline T-SQL Statements
Statements History
Team Fondation Server Check-in Policies
T-SQL Script Summary
Refactoring T-SQL code
Analysis
Architecture
Analysis Rule
Analysis Context
SQML Schema Reference
XSLT Extension Functions
How To: Extend Analysis Template with Visual Studio
How To: Create Analysis Rule with Visual Studio
How To: Create Analysis Rule with Rule Designer
Analysis Rules
Design Rules
Explicit Rules
Naming Rules
Performance Rules
Maintenance Rules
All Rules
EX0001 : Identify objects used in the script.
EX0002 : Get object dependencies - Objects on which database objects depend.
EX0003 : Get object dependencies - Objects that depend on other database objects.
EX0004 : Find identifier references inside the T-SQL script.
EX0005 : Check script for data modifying statements - INSERT,UPDATE,DELETE or EXECUTE.
EX0006 : Identify possible missing Foreign Keys.
EX0007 : List all DML and DDL triggers in current database.
EX0008 : Generate CREATE INDEX statements for all columns included in foreign keys.
EX0009 : Consider adding proper comment block before each database object create statement.
EX0010 : Identify missing indexes using dynamic management views information.
EX0011 : Identify ineffiecient indexes using dynamic management views information.
EX0012 : Displays memory usage information for the current database.
EX0013 : Identify fragmented indexes that need rebuilding or reindexing.
EX0014 : List the last execution status of all available SQL Server jobs.
EX0015 : Find Best Clustered Index
EX0016 : Generate DROP INDEX statements for inefficient indexes using dynamic management views information.
EX0017 : Generate ALTER INDEX statements for rebuilding or reorganizing fragmented indexes.
EX0018 : Analyze execution plan and check for high cost operations.
SA0001 : Equality and inequality comparisons involving a NULL constant found. Use IS NULL or IS NOT NULL.
SA0002 : Variable declared but never used.
SA0003 : Variable used but not previously assigned.
SA0004 : Variable assigned but value never used.
SA0005 : Non-ANSI outer join syntax.
SA0006 : Non-ANSI inner join syntax.
SA0007 : Pattern starting with "%" in LIKE predicate.
SA0008 : Deprecated syntax string = expression_alias.
SA0009 : Consider using a table variable instead temporary table.
SA0010 : Use TRY..CATCH or check the @@ERROR variable after executing data manipulation statement.
SA0011 : SELECT * in stored procedures, views and table-valued functions.
SA0012 : Use SCOPE_IDENTITY() instead @@IDENTITY.
SA0013 : Avoid returning results in triggers.
SA0014 : Avoid 'fn_' prefix when naming functions.
SA0015 : Avoid 'sp_' prefix when naming stored procedures.
SA0016 : Use of very small variable length type (size 1 or 2).
SA0017 : SET NOCOUNT ON option in stored procedures and triggers.
SA0018 : Support for constants in ORDER BY clause have been deprecated.
SA0019 : TOP clause used in a query without an ORDER BY clause.
SA0020 : Always use a column list in INSERT statements.
SA0021 : Deprecated usage of table hints without WITH keyword.
SA0022 : Index type (CLUSTERED or NONCLUSTERED) not specified.
SA0023 : Avoid using not equal operator (<>,!=) in the WHERE clause.
SA0024 : Local cursor not closed.
SA0025 : Local cursor not explicitly deallocated.
SA0026 : Local cursor variable not explicitly deallocated.
SA0027 : Avoid wrapping filtering columns within a function in the WHERE clause.
SA0028 : Deterministic function calls can be extracted from the WHERE clause to avoid unnecessary table scan.
SA0029 : Input parameter never used.
SA0030 : Output parameter never assigned.
SA0031 : Avoid GOTO statement to improve readability.
SA0032 : Avoid using NOT IN predicate in the WHERE clause.
SA0033 : Do not use the GROUP BY clause without an aggregate function.
SA0034 : Use parentheses to improve readability and avoid mistakes because of logical operator precedence.
SA0035 : TODO,HACK or UNDONE phrase found in a comment.
SA0036 : DELETE statement without WHERE clause.
SA0037 : UPDATE statement without WHERE clause.
SA0038 : The WHERE clause contains comparison which evaluate to TRUE.
SA0039 : The WHERE clause contains comparison which evaluate to FALSE.
SA0040 : Consider moving the column reference to one side of the comparison operator in order to use the column index.
SA0041 : Avoid joining with views.
SA0042A : Avoid using special characters in object names. (Context Only)
SA0042B : Avoid using special characters in object names. (Batch)
SA0043A : Avoid using reserved words for type names. (Context Only)
SA0043B : Avoid using reserved words for type names. (Batch)
SA0044 : Consider creating indexes on all columns included in foreign keys.
SA0045 : Consider updating statistics as they appear outdated and may mislead the query optimizer.
SA0046 : Consider creating statistics on all composite index columns.
SA0047 : Consider indexing the column as it is used in a WHERE clause or JOIN condition.
SA0048 : Table does not have a primary key.
SA0049 : Table does not have a clustered index.
SA0050 : Do not create clustered index on UNIQUEIDENTIFIER columns.
SA0051 : Possible result of Cartesian product due to incomplete table joins.
SA0052 : Avoid using undocumented and deprecated stored procedures.
SA0053A : Don’t use deprecated TEXT,NTEXT and IMAGE data types. ( Context Only)
SA0053B : Don’t use deprecated TEXT,NTEXT and IMAGE data types. (Batch)
SA0054 : Avoid modification of parameters in a stored procedure prior to use in a query.
SA0055 : Consider indexing the columns referenced by IN predicates in order to avoid table scans.
SA0056 : Index has exact duplicate or overlapping index.
SA0057 : Consider using EXISTS predicate instead of IN predicate.
SA0058 : Avoid converting dates to string during date comparison.
SA0059A : Check database for objects created with different than default or specified collation.
SA0059B : Check for usage of collation different than the database default or the specified collation.
SA0060 : The sp_xml_preparedocument procedure call is not paired with a following sp_xml_removedocument call.
SA0061A : Check all Tables in the current database for following specified naming convention.(Context Only)
SA0061B : Check table names used in CREATE TABLE statements for table name following specified naming convention.(Batch)
SA0062A : Check all Functions in the current database for following specified naming convention.(Context Only)
SA0062B : Check function names used in CREATE FUNCTION statements for following specified naming convention. (Batch)
SA0063A : Check all Views in the current database for following specified naming convention.(Context Only)
SA0063B : Check view names used in CREATE VIEW statements for following specified naming convention. (Batch)
SA0064A : Check all Stored Procedures in the current database for following specified naming convention.(Context Only)
SA0064B : Check stored procedure names used in CREATE PROCEDURE statements for following specified naming convention. (Batch)
SA0065A : Check all Triggers for for following specified naming convention.(Context Only)
SA0065B : Check trigger names used in CREATE TRIGGER statements for for following specified naming convention. (Batch)
SA0066A : Check all Columns for following specified naming convention.(Context Only)
SA0067A : Check all Unique Key Constraints in the current database for following specified naming convention.(Context Only)
SA0068A : Check all Check Constraints in the current database for following specified naming convention.(Context Only)
SA0069A : Check all Default Constraints in the current database for following specified naming convention.(Context Only)
SA0070A : Check all Primary Key Constraints in the current database for following specified naming convention.(Context Only)
SA0071A : Check all Foreign Key Constraints in the current database for following specified naming convention.(Context Only)
SA0072A : Check all Non-Key Indexes in the current database for following specified naming convention.(Context Only)
SA0073A : Check all User-Defined Types in the current database for following specified naming convention.(Context Only)
SA0074A : Check all Schemas in the current database for following specified naming convention.(Context Only)
SA0075 : Avoid constraints created with system generated name.
SA0076 : Check UPDATE and DELETE statements for not filtering using all the PRIMAR KEY columns of the target table.
SA0077 : Avoid executing dynamic code using EXECUTE statement.
SA0078 : Statement is not terminated with semicolon.
SA0079 : Avoid using column numbers in ORDER BY clause.
SA0080 : Do not use VARCHAR or NVARCHAR data types without specifying length.
SA0081 : Do not use DECIMAL or NUMERIC data types without specifying precision and scale.
SA0082 : Consider prefixing column names with table name or table alias.
SA0083 : Consider proactively checking the logical and physical integrity of all the objects in the database.
SA0084 : Data purity check is not enabled for the current database.
SA0085 : Check database objects for missing specific extended properties.
Refactoring
Encapsulate as Stored Procedure
Encapsulate as Inline Function
Encapsulate as Scalar Function
Encapsulate as View
Encapsulate as SP_ExecuteSQL Call
Extract to Separate Script
Extract T-SQL Object's Body to Separate Script
Expand SP_ExecuteSQL Call
Qualify Object Names
Expand Wildcards
Add Statement Terminators
Command Line Tool (enlight.exe)
Command Line Tool - Analyze
Command Line Tool - Layout
Command Line Tool - Context
Command Line Tool - Configure
Command Line Tool - License
Integration with MSBild and NAnt
MSBuild
NAnt
Code Formatting
Expressions
Logical Expression Rules
Operator Rules
General
Comma Rules
Comment Rules
Delimiter Rules
Miscellaneous Rules
Optional Token Rules
Parenthesis Rules
Token Case Rules
Statements
Data Statement Rules
General Statement Rules
Schema Statement Rules
SQL Enlight SDK Reference
Ubitsoft.SqlEnlight Namespace
Ubitsoft.SqlEnlight.Model Namespace
Ubitsoft.SqlEnlight.Model.Analysis Namespace
AdditionalInfo Class
AdditionalInfo Members
AdditionalInfo Constructor
AdditionalInfo Constructor
AdditionalInfo Constructor (String)
AdditionalInfo Constructor (String, String)
AdditionalInfo Methods
AdditionalInfo Properties
Description Property
Url Property
AnalysisGroup Class
AnalysisGroup Members
AnalysisGroup Constructor
AnalysisGroup Constructor
AnalysisGroup Constructor (String, String, String, String[], Boolean)
AnalysisGroup Methods
AddRule Method
Clone Method
ContainsRule Method
RemoveRule Method
AnalysisGroup Properties
Description Property
DisplayName Property
Enabled Property
Name Property
Rules Property
AnalysisRule Class
AnalysisRule Members
AnalysisRule Constructor
AnalysisRule Constructor
AnalysisRule Constructor (String, String, String, AnalysisRuleSeverityLevel, AnalysisRuleScope)
AnalysisRule Constructor (String, String, String, AnalysisRuleType, AnalysisRuleSeverityLevel)
AnalysisRule Methods
Clone Method
GetDescriptionAsPlainText Method
GetParametersDefaultValues Method
LoadFromFile Method
SaveToFile Method
SetParameters Method
ToString Method
AnalysisRule Properties
AdditionalInfos Property
Author Property
Description Property
IsXmlDescription Property
LastUpdated Property
Message Property
Name Property
Parameters Property
RequireRuleParameters Property
RuleExpression Property
Scope Property
SeverityLevel Property
TestScript Property
Type Property
AnalysisRuleParameter Class
AnalysisRuleParameter Members
AnalysisRuleParameter Constructor
AnalysisRuleParameter Constructor
AnalysisRuleParameter Constructor (String, String, TypedParameterValue[], String)
AnalysisRuleParameter Methods
Clone Method
IsValid Method
ValidateName Method
AnalysisRuleParameter Properties
DefaultType Property
DefaultValue Property
Description Property
Name Property
PredefinedValues Property
AnalysisRuleParametersValues Class
AnalysisRuleParametersValues Members
AnalysisRuleParametersValues Constructor
AnalysisRuleParametersValues Constructor
AnalysisRuleParametersValues Constructor (String)
AnalysisRuleParametersValues Methods
AnalysisRuleParametersValues Properties
Name Property
Parameters Property
AnalysisRuleScope Enumeration
AnalysisRuleSeverityLevel Enumeration
AnalysisRuleType Enumeration
AnalysisTemplate Class
AnalysisTemplate Members
AnalysisTemplate Constructor
AnalysisTemplate Methods
ActivateRule Method
AddRule Method
Clone Method
CreateDefault Method
DeactiveRule Method
GetAllGroups Method
GetAllRules Method
GetRulesAsString Method
GetRulesAsString Method (IEnumerable(String))
GetRulesAsString Method (IEnumerable(AnalysisRule))
LoadExternalRules Method
LoadFromAssembly Method
LoadFromXmlFile Method
RemoveRule Method
SaveExternalRules Method
SaveToFile Method
SaveToFile Method (String, AnalysisTemplate)
SaveToFile Method (String, AnalysisTemplate, Boolean)
SetAllGroups Method
SetAllRules Method
AnalysisTemplate Properties
ActiveRules Property
ExternalRuleDefinitionFiles Property
Groups Property
LastModifiedDate Property
Rules Property
IAnalysisRule Interface
IAnalysisRule Members
IAnalysisRule Methods
GetParametersDefaultValues Method
SetParameters Method
IAnalysisRule Properties
AdditionalInfos Property
Author Property
Description Property
LastUpdated Property
Message Property
Name Property
Parameters Property
RequireRuleParameters Property
RuleExpression Property
Scope Property
SeverityLevel Property
TestScript Property
Type Property
NamedParameterValue Class
NamedParameterValue Members
NamedParameterValue Constructor
NamedParameterValue Constructor
NamedParameterValue Constructor (String, String)
NamedParameterValue Constructor (String, String, ParameterValueType)
NamedParameterValue Methods
IsValid Method
NamedParameterValue Properties
Name Property
ParameterValueType Enumeration
TypedParameterValue Class
TypedParameterValue Members
TypedParameterValue Constructor
TypedParameterValue Constructor
TypedParameterValue Constructor (String)
TypedParameterValue Constructor (ParameterValueType, String)
TypedParameterValue Methods
TypedParameterValue Properties
Value Property
ValueType Property
Error Class
Error Members
Error Constructor
Error Methods
ToString Method
Error Properties
Code Property
Context Property
Description Property
Line Property
LineOffset Property
Near Property
Source Property
Type Property
ErrorType Enumeration
Ubitsoft.SqlEnlight.Sdk Namespace
AnalysisTransformationOverrideHandler Delegate
ISdkAnalysisService Interface
ISdkAnalysisService Members
ISdkAnalysisService Methods
AnalyzeFiles Method
AnalyzeServerObjects Method
ApplyBatchRule Method
ApplyBatchRule Method (AnalysisRule, Dictionary(String, String), String, SqlConnection)
ApplyBatchRule Method (AnalysisRule, Dictionary(String, String), String, XPathNavigator)
ApplyContextRule Method
ApplyContextRule Method (AnalysisRule, Dictionary(String, String), SqlConnection)
ApplyContextRule Method (AnalysisRule, Dictionary(String, String), XPathNavigator)
ApplyRule Method
ApplyRule Method (AnalysisRule, Dictionary(String, String), String, SqlConnection)
ApplyRule Method (AnalysisRule, Dictionary(String, String), String, XPathNavigator)
Debug Method
Debug Method (AnalysisRule, String, Dictionary(String, String), SqlConnection, Object)
Debug Method (AnalysisRule, String, Dictionary(String, String), SqlConnection, AnalysisTransformationOverrideHandler)
Debug Method (AnalysisRule, String, Dictionary(String, String), XPathNavigator, Object)
Debug Method (AnalysisRule, String, Dictionary(String, String), XPathNavigator, AnalysisTransformationOverrideHandler)
GetContext Method
GetContextXml Method
Test Method
Test Method (AnalysisRule, Dictionary(String, String), SqlConnection)
Test Method (AnalysisRule, Dictionary(String, String), XPathNavigator)
Test Method (AnalysisRule, String, Dictionary(String, String), SqlConnection)
Test Method (AnalysisRule, String, Dictionary(String, String), XPathNavigator)
ISdkParserService Interface
ISdkParserService Members
ISdkParserService Methods
ParseBatch Method
ValidateBatch Method
ISdkServiceBase Interface
ISdkServiceProvider Interface
ISdkServiceProvider Members
ISdkServiceProvider Methods
GetService Method
GetService(T) Method
GetService Method (Guid)
ISdkServiceProvider Properties
Analysis Property
Parser Property
ISqkLayoutService Interface
ISqkLayoutService Members
ISqkLayoutService Methods
LayoutFiles Method
SdkServiceProvider Class
SdkServiceProvider Members
SdkServiceProvider Constructor
SdkServiceProvider Methods
GetService Method
GetService(T) Method
GetService Method (Guid)
SdkServiceProvider Properties
Analysis Property
Parser Property
About Ubitsoft
This page uses an IFRAME but your browser does not support it.