Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Delinda
Constraint Violating Yak Guru
315 Posts |
 Posted - 2009-11-15 : 01:14:14
|
| Me looking the best practice to store a million of data in a table.Currently, me partition table into tbl_yyyymm. Let's say, tTrip_200910, tTrip_200911 and so on.What's the best practice to handle multi-million row in the database? As a result, we can Query it without the performance problem |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2009-11-15 : 01:19:14
|
| A million?Any decent server can handle that.________________________________________________If it is not practically useful, then it is practically useless.________________________________________________ |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-15 : 01:25:54
|
any decent index can anyway  |
|
|
|
|
|
|
What the best practice to store a million of data?