Export (0) Print
Expand All

Transact-SQL Performance Issues

When you analyze the Transact-SQL code in your database project, one or more warnings might be categorized as performance issues. You should address a performance issue to avoid the following situation:

  • A table scan will occur when the code is executed.

In general, you might suppress a performance issue if the table contains so little data that a scan will not cause performance to drop significantly.

Analyzing Database Code to Improve Code Quality

Describes how you can find common design, performance, and naming issues in your Transact-SQL code.

Transact-SQL Design Issues

Contains links to the different types of design issues that you might find when you analyze your database code.

Transact-SQL Naming Issues

Contains links to the different types of naming issues that you might find when you analyze your database code.

Walkthrough: Analyze Transact-SQL Code for an Existing Database

Describes how you can identify coding issues in the AdventureWorks2008 sample database.

Create and Register Additional Rules for Analyzing Database Code

Describes how you can create your own rules for analyzing database code to identify issues that are not found by the rules that Visual Studio Premium includes.

Community Additions

ADD
Show:
© 2014 Microsoft