TOP N Biggest Tables in every database

Sometime it may be useful to find all the big tables in all databases. There may be performance issue on the system and it can be necessary to move some tables to another disk to decrease the disk latency. So additional File Groups and Files can be created and some of those big tables can…

1

TSQL for database size, data and log available size

What are our databases sizes in SQL Server? How much space is Available? How can I prevent the automatic auto growth of data and log files? How can I be notified if there is not enough space in the log file? It will be really good to consolidate all the SQL servers with their databases…

2