We have a few tables each with near 100 million rows of data. A co-worker has these tables setup with partitions based on a date field. Our disk space is starting to run low and knowing that ...
while monitoring when checking database space used,my favorites are use indexinternals sp_spaceused select (sum(size)*8)/1024 as size From sys.master_files where name like 'indexinternals%' ...
What does the green and blue indicate from the below scrteenshots of disk activity on SQL Server database server? Thanks!
My database has 16MB of space left. I used to just truncate as I was taught but I found these links that advise against truncating: ...