title: How to design this database?
body: <p>I have to design a database to store log data but I don't have experience before. My table contains about 19 columns (about 500 bytes each row) and daily grows up to 30.000 new rows. My app must be able to query effectively again this table.</p>
  
  <p>I'm using SQL Server 2005.</p>
  
  <p>How can I design this database? </p>
  
  <p>EDIT: data I want to store contains a lot of type: datetime, string, short and int. NULL cells are about 25% in total :)</p>