Dear All,
I need solution for manage 2 Crores of data in MS-SQL 2008(standard edition).
1.Every day average of 20,000 rows inserted into specified table.
2.I need to check 2 years of data to avoid duplicate data.
3.Get report based on selected date range.
How can i split SQL table and manage 2 years data
Please let me know i'm in critical condition.