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 |
|
ujjaval
Posting Yak Master
108 Posts |
 Posted - 2006-01-18 : 23:52:32
|
| I have upgraded a database.Mainly I have done these things in updation:1. Reduce the field sizes of varchar fields from 20 to 3 or something like that.2. Added few new columns.3. Deleted Few varchar fields and created a bitmap column to store all the data in it with reference table for that.This may not be required in this.But I just want to have the idea of difference in terms of space utilization for the new database compare to my old database.How can I check that??Thanks,Ujjaval |
|
|
pomela
Starting Member
15 Posts |
Posted - 2006-01-19 : 02:52:59
|
| You can use sp_spaceused, or the EM taskpad view or just take a look at the files size in the NT directory. The file size won't decrease automatically unless you have a log backup schedule OR a shrink process done. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
how to calculate the size of database?