SQL Server Knowledge by Batuhan YILDIZ

Notes From The Field Experiences and Useful Scripts - By Microsoft Premier Field Engineer

Browse by Tags

Tagged Content List
  • Blog Post: 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 be moved to...
  • Blog Post: 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 with the space...
Page 1 of 1 (2 items)