This will be a quick one!
Some days ago this happened:
“Hey, DBAs, why your monitoring system shows us that there is available space in our database and when we see the Space Available property on the particular database it shows 0, zero, Ziffer, a huge NULL?”
Well, I don’t know! Oh… okay, just lied. I know. Just run DBCC UPDATEUSAGE on the problematic database and voilà!
Now, the app team can sleep peacefully and dream of their future peace of code which will fill up tempdb(ups…didn’t say that out loud, did I?), because when they go and click the DB properties they see this: