How Manage 2 Crores of data in MS-SQL

Question

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.

 

 

 

Answer 1

Hello Vaibhav,

 

follow below link. 

 

http://www.c-sharpcorner.com/forums/datagridview-allow-editing-on-single-column