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 |
|
sql777
Constraint Violating Yak Guru
314 Posts |
 Posted - 2006-06-02 : 17:57:09
|
| Hi,1. is it possible for me to see a report of which tables are consuming the most disk space?2. how can I shrink this db? I know it can't be that big! |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2006-06-02 : 19:24:11
|
| Also, what is your recovery model set to for this database? Oftentimes when people say "I don't know why my database is so large!" they don't realize that their transaction logs are 90% of the total space used.Michael<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda>Opinions expressed in this post are not necessarily those of TeleVox Software, inc. All information is provided "AS IS" with no warranties and confers no rights. |
 |
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
my db is 2 GIGS, how can I shrink it?