We can know how much space a database is occupied in hard disk by using sp_spaceused function. If we want to find all database sizes at a time, we have to provide use and sp_spaceused for all databases. It takes some time to write all those T-sql statments. My script will find each and every database size with out using sp_spaceused function. It will save your time and server time. Try this,
When doing bulk data changes it may be beneficial to disable indexes prior to starting the operation. Fortunately, SQL's rich metadata makes this very easy to automate in a robust fashion.