Today, free SQL schema analysis tool was released named SqlTac Lite. Running this onto a default KiGG database instance (itself running on SQL Server 2008) yielded many errors that should be reviewed, such as:
* StoryView and UserScore tables do not contain a Natural Key.
* KnownSource table PK has one or more segments which are not marked as identity/unique identifier.
* CommentSubscribtion and StoryMarkAsSpam tables contain a multiple segmented primary key.
* Id and UniqueName columns occur many times with one or more inconsistent definitions.
Would someone please take a look at this handy tool and consider using it for the next iteration? Since this project is trying to go best practices, using all tools available will yield quantifiable results to the end result.
Thank you for this wonderful project!