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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Purge data in database

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

Go to Top of Page

Nazim
A custom title

1408 Posts

Posted - 2002-04-16 : 04:43:40
I dont too

let 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?



--------------------------------------------------------------
Go to Top of Page

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 ..
Go to Top of Page

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?

Go to Top of Page
   

- Advertisement -