Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
From novice to tech pro — start learning today.
http://searchsqlserver.techtarget.com/tutorial/Tutorial-Performance-tuning-SQL-Server-via-queries-indexes-and-more
For Data base design the below site will surely suffice the requirement:
http://www.mssqltips.com/sql-server-tip-category/10/database-design/
The attached doc's might will help please got through them
DDESIGN-ALLy.pdf
SQL-Server-Performance-Tuning-fo.docx