How to manage lacs of data in one table

Jun 9 2011 6:44 AM

In database,there is one table named tblRecord in which daily 1000 records get inserted, after 1 month there would be 30000 and in one year 360000. If this happened then it would be difficult to retrieve the data from this table. Please suggest me, how to manage this much data or more than that.

Answers (4)

Sending of mail using jobs in sql2005

How to do sum of column when there is 1million records