Detected issues

Group # Description Version Day
Code 1.1 Procedures with SP_ 0.6.3.0 2014/01/10
1.2 VarChar Size Problems 0.6.3.0 2014/01/10
1.3 Decimal Size Problem 0.6.3.0 2014/01/10
1.4 Undocumented Procedures 0.6.3.0 2014/01/10
1.5 Procedures without SET NOCOUNT ON 0.6.3.0 2014/01/10
1.6 Procedures with SET ROWCOUNT 0.6.3.0 2014/01/10
1.7 Procedures with @@Identity 0.6.3.0 2014/01/10
1.8 Procedures with dynamic sql 0.6.3.0 2014/01/10
1.9 Procedures using dynamic sql without sp_executesql 0.6.3.0 2014/01/10
Column 2.1 Column Name Problems 0.6.3.0 2014/01/10
2.2 Columns with float data type 0.6.3.0 2014/01/10
2.3 Columns with image data type 0.6.3.0 2014/01/10
2.4 Tables with text/ntext 0.6.3.0 2014/01/10
2.5 Collation Mismatch 0.6.3.0 2014/01/10
2.6 UniqueIdentifier with NewId 0.6.3.0 2014/01/10
Table/Views 3.1 Table Prefix 0.6.3.0 2014/01/10
3.2 Table Name Problems 0.6.3.0 2014/01/10
3.3 Missing Foreign Keys 0.6.3.0 2014/01/10
3.4 Wide Tables 0.6.3.0 2014/01/10
3.5 Tables without a primary key 0.6.3.0 2014/01/10
3.6 Empty Tables 0.6.3.0 2014/01/10
3.7 Views with order by N/A TDA
3.8 Unnamed Constraints 0.6.3.0 2014/01/10
Indexes 4.1 Overlapping Indexes 0.6.3.0 2014/01/10
4.2 Unused Indexes 0.6.3.0 2014/01/10
4.3 Missing Indexes 0.6.3.0 2014/01/10
4.4 Indexes with problems in fillfactor setting 0.6.3.0 2014/01/10
4.5 Indexes with forwarded records 0.6.3.0 2014/01/10
4.6 Indexes for reorganize 0.6.3.0 2014/01/10
4.7 Indexes for rebuild 0.6.3.0 2014/01/10
4.8 Indexes for statistics update 0.6.3.0 2014/01/10
Configuration 5.1 Database Collation 0.6.3.0 2014/01/10
5.2 Auto Close 0.6.3.0 2014/01/10
5.3 Auto Create 0.6.3.0 2014/01/10
5.4 Auto Shrink 0.6.3.0 2014/01/10
5.5 Auto Update 0.6.3.0 2014/01/10
5.6 Compatibility Level 0.6.3.0 2014/01/10
5.7 Login Language 0.6.3.0 2014/01/10
5.8 Old Backups 0.6.3.0 2014/01/10
5.9 Orphaned Users 0.6.3.0 2014/01/10
5.10 User Aliases 0.6.3.0 2014/01/10
5.11 Ad Hoc Distributed Queries 0.6.3.0 2014/01/10
5.12 CLR 0.6.3.0 2014/01/10
5.13 Database and log files on the same physical disk 0.6.3.0 2014/01/10
5.14 Database Mail 0.6.3.0 2014/01/10
5.15 Deprecated Features 0.6.3.0 2014/01/10
5.16 Instant File Initialization 0.6.3.0 2014/01/10
5.17 Max Degree of Parallelism 0.6.3.0 2014/01/10
5.18 OLE Automation Procedures 0.6.3.0 2014/01/10
5.19 Service Account 0.6.3.0 2014/01/10
5.20 SMO and DMO 0.6.3.0 2014/01/10
5.21 SQL Server Agent Service 0.6.3.0 2014/01/10
5.22 xp cmdshell 0.6.3.0 2014/01/10
Health 6.1 Buffer cache hit ratio 0.6.3.0 2014/01/10
6.2 Page life expectancy 0.6.3.0 2014/01/10
Monitoring 7.1 Connections and blocking 0.6.3.0 2014/01/10
7.2 High processor utilization 0.6.3.0 2014/01/10
7.3 Memory utilization 0.6.3.0 2014/01/10
Audit 8.1 Instance properties 0.6.3.0 2014/01/10
8.2 Instance configuration 0.6.3.0 2014/01/10
8.3 SQL Agent Jobs 0.6.3.0 2014/01/10
8.4 Linked Servers 0.6.3.0 2014/01/10
Database 9.1 Size 0.6.3.0 2014/01/10
9.2 Compatibility Level 0.6.3.0 2014/01/10
9.3 Backup status 0.6.3.0 2014/01/10
9.4 Restoration status 0.6.3.0 2014/01/10
Instance 10.1 Errors in Instance logs 0.6.3.0 2014/01/10
Issues based on DMV 11.1 Most Expensive Queries 0.6.3.0 2014/01/10
11.2 Most Expensive Procedures 0.6.3.0 2014/01/10