How Manage 2 Crores of data in MS-SQL

Oct 20 2016 7:00 AM

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.

Answers (1)

How can I use order by in dynamic query?