SQL Learner - VKG (12/7/2016)
Hello Guys,I a table of around 10 GB size. Recovery model of database (SQL Server 2005) is simple. For some requirement, I added a clustered index on table. Then, disk space started decreasing by 1 GB. I got worried and stopped the process. Later, I found that there were around 10 data file growth events occurred on that table. Could you please let me know what step should I take? How can I able to add an index?
Are those 10 GBs too much so you have to worry about?
Just try. The clustered index is the data of the table. While being created, the process must obtain some more space.
Igor Micev,My blog: www.igormicev.com