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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-03-20 : 09:10:12
|
| Pinakin writes " How to partition database Year Wise????? How can i handle old data in New year????? Whar i have to do during new year?? should i have create a new database in new year or i have to do anything else?? but what???? from Pinakin Patel (9879057847)(Shri Ram Organization)" |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-03-20 : 09:34:28
|
but nothing.keep all your data in one table. a few million rows isn't a problem at all... you just need to index it properly.if you must have separated data for years create a table for each year.Go with the flow & have fun! Else fight the flow  |
 |
|
|
|
|
|
About database