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 - 2004-11-26 : 08:54:44
|
| sorin writes "good afternoon.here's my problem.hope you can help me.i have this table that contains around 60 millions records.i have added two columns : an integer and a nvarchar(2000)-when it was empty.compared with the old table - it has grown almost ten times- having the same number of records.no indexes added.the nvarchar(2000) contains only 23 characters per record.i have to keep this representation.and now :could you please tell me:-why does the database grown so much?-how can i save the space (without losing the 2 columns)?thank you.if you can- please huury with the answer.the harddisk is almost full...:)" |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-11-26 : 09:12:39
|
DBCC SHRINKDATABASE 'dbname' should help youGo with the flow & have fun! Else fight the flow  |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2004-11-26 : 10:08:21
|
| Truncate the log ...------------------------I think, therefore I am |
|
|
|
|
|
|
excessive database growth