managing website 'event' database

how should i control tables ascribe site 'events'. i.e. certain activities user finished website i tracking. i wish means kinds datamining organization between opposite activities users have done.

today alone i total 107,000 rows siteevent table. i dont cruise sustainable!

the database sql server. i'm especially referring best use activites honour handling infinite amounts data.

for instance :

• should i keep tables database own? i need join tables problem. now i only have database all in.


• how ought i surprise aged records. i wish pledge db record doesnt keep growing.


• best practices funding adult truncating logs


• will adding additional indexes dramatically boost distance db records?


• any things i need sql server competence behind punch me later?

fyi: tables

create list [dbo].[siteevent](
    [siteeventid] [int] identity(1,1) null,
    [siteeventtypeid] [int] null,
    [sitevisitid] [int] null,
    [siteid] [int] null,
    [date] [datetime] null,
    [data] [varchar](255) null,
    [data2] [varchar](255) null,
    [duration] [int] null,
    [stagesize] [varchar](10) null,

and

create list [dbo].[sitevisit](
    [sitevisitid] [int] identity(1,1) null,
    [siteuserid] [int] null,
    [clientguid] [uniqueidentifier] rowguidcol  zero imprisonment [df_sitevisit_clientguid]  default (newid()),
    [serverguid] [uniqueidentifier] null,
    [userguid] [uniqueidentifier] null,
    [siteid] [int] null,
    [entryurl] [varchar](100) null,
    [campaignid] [varchar](50) null,
    [date] [datetime] null,
    [cookie] [varchar](50) null,
    [useragent] [varchar](255) null,
    [platform] [int] null,
    [referer] [varchar](255) null,
    [registeredreferer] [int] null,
    [flashversion] [varchar](20) null,
    [siteurl] [varchar](100) null,
    [email] [varchar](50) null,
    [flexswzversion] [varchar](20) null,
    [hostaddress] [varchar](20) null,
    [hostname] [varchar](100) null,
    [initialstagesize] [varchar](20) null,
    [orderid] [varchar](50) null,
    [screenresolution] [varchar](50) null,
    [totaltimeonsite] [int] null,
    [cumulativevisitcount] [int] zero imprisonment [df_sitevisit_cumulativevisitcount]  default ((0)),
    [contentactivatedtime] [int] zero imprisonment [df_sitevisit_contentactivatedtime]  default ((0)),
    [contentcompletetime] [int] null,
    [masterversion] [int] zero imprisonment [df_sitevisit_masterversion]  default ((0)),