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.
Visual Studio Premium identifies the following design issues: