Tag Info

New answers tagged


in my case it was 900GB with around 30 big dbo.TaskUsage_PartitionXX tables. 1- go to SSMS and by opening object Explorer (f7) of WSS_UsageApplication find the big tables which in most cases are TaskUsages 2- create a series of truncate and run them truncate TABLE [dbo].TaskUsage_PartitionXX 3- shrink your whole database to forexample 5% free space ...

Top 50 recent answers are included