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 - 2002-04-15 : 23:37:43
|
| Tracy writes "When we initially implement a database, how do we maintain tables in the database to avoid the rows become so large (e.g. purge data in a database into another tables)? is it this maintenance being implemented in the later stage or we can use some methods to handle the above conditions earlier in the first implementation?Thank You!" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-04-16 : 02:26:29
|
Now, It is late, so maybe it is just me, but I don't have the foggiest idea what she is asking? -Chad |
 |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-04-16 : 04:43:40
|
I dont toolet me guess if she means the data going beyond what a table can hold. Dont worry tracy Sql server can hold terrabyes of data. if therez more to it you can always partition the data into different servers or databases.And, I Dont have any Remote idea what am answering  quote: Now, It is late, so maybe it is just me, but I don't have the foggiest idea what she is asking?
-------------------------------------------------------------- |
 |
|
|
Da_Retina
Posting Yak Master
109 Posts |
Posted - 2002-04-17 : 07:27:55
|
maybe she is asking about SHRINKING FILES or DATABASES ?..or TRUNCATING a LOG file when it gets into SUMO OLYMPICS!!  ------------------If I am to do it,I will, and NOW .. |
 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2002-04-17 : 07:51:42
|
| Are we talking about archiving 'old' data to control the size of the active database? |
 |
|
|
|
|
|