We are running SQL Server 2008 Version 10.00.5828.
There is some data which is loaded into particular tables for our cockpit use, due to which the database is growing at 6GB per day.
Than we ran some deletion programs to remove the old data from our tables, though the records/rows are removed the size of the database is not reducing.
Though the row count is decreasing, still the table size is growing normally.
Can you please advice how to handle this situation ? Do I need do DB Shrink to release the space from DB or any other suggestions to fix this issue ?