Designing databases is not just about the database product you use (in your case Microsoft SQL Server 2008 R2). It's also about the techniques to store your data in an efficient way (creating tables, working with primary and foreign keys, constraints, nullable
columns,...) for which the basis lies in database normalization:
http://en.wikipedia.org/wiki/Database_normalization
About this you can find many resources on the web (like the wikipedia link above) and there are also books available:
Database Processing: Fundamentals, Design and Implementation By David M. Kroenke
Database Systems: Design, Implementation and Management By Peter Rob, Carlos Coronel
Database Principles and Design By Colin Ritchie
Dimitri C. - Please mark the replies as answers if they help! Thanks.