Large Table handling

Asked Feb 23 '14 at 09:03

Active Feb 23 '14 at 09:28

Viewed 69 times

We are having table that contains 6,616,711 records in it. I want to know, How to manage this table? If there is SO question similar to this please give me link. Having following concern, too.

How to manage large database?
What is best system/hardware configuration for this type of scenario?
Partitioning this table will help us?

edited Feb 23 '14 at 09:28

asked Feb 23 '14 at 09:03

Vicky Thakor

3,847
7
42
67

1

6.6 million or 66 million? – bvj Feb 23 '14 at 09:06
I think this question would be better suited at [dba.se]. – jpw Feb 23 '14 at 09:28
What do you mean by 'manage' ? – Saurabh R S Feb 23 '14 at 09:35
@Luftwaffe that server will respond faster steps should be taken care while dealing with large database – Vicky Thakor Feb 23 '14 at 09:37
check this http://stackoverflow.com/questions/14930696/querying-large-table-in-sql-server-2008 – Saurabh R S Feb 23 '14 at 09:41

Large Table handling

0 Answers0