Recently I was invited to participate in a podcast. Not “just a podcast” though, because this one is hosted by two guys that I have spoke and recorded at least 3 SQLHangouts up until now with – Matan Yungman(t|b) and Guy Glanster(t|b) from Madeira Services. We chatted about a lot of things and – why most of the trainings nowadays are crappy(especially the Microsoft ones), what we were working on recently and I was also asked to be the first on their show to play a really interesting game. Enjoy listening!
Space Available shows 0 in SSMS
This will be a quick one!
Some days ago this happened:
Application team:
“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: