Before I complete my question let me provide context. I’ve received an alert saying that a specific database could not allocate a new page (disk was full) The message that you will see on the SQL Server Error log is: I didn’t know the database structure or what is saved there, so I picked up a script from my toolbelt that shreds all indexes from all table. Just some information like number of rows and space that it is occupying.

Continue reading

Author's picture

Cláudio Silva

Data Platform Architect and PowerShell lover.

Data Platform Architect

Portugal