I am new to mssql server and i need some help. There is a table on one of my databases that occupies a lot of space. And the space usage is as follows: (all values in KB)
This table takes up almost 80% of my database size, and the information is this table just captures the time spent by a user on the website(not very critical data)
I would like to know how to delete the entire index (which is what is occupying most space) to free up disk space. the index is a clustered index.
can someone pl tell me the steps to achieve this? I am new to mssql and my knowledge is just limited to getting along with navigating thru the ssms