New answers tagged


Restart SQL Server and see if they suddenly match. There is a documented behaviour where if tempdb grows you can get different results depending on how you query what size it is. For example sys.master_files shows tempdb size on start; sys.database_files shows actual size (as do some of the Fileproperty() function results). Nacho Alonso Portillo wrote on ...

Top 50 recent answers are included