I was looking around for a tool that will tell me how much space each table in my SQLServer database. After little search I found this sql script, which really helped me finding which table eat away all the space in the database.
btw - sometimes people forget that if you don't define your backup mode to "Simple" the transaction log will grow unless you backup the database.
Monday, September 3, 2007
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment