You can say straight forward NO
Why?
If you have auto shrink enabled in your environment then it increases the fragmentation level of indexes so performance will go down
Even you save some space after auto shrink but it’s not recommendable.
A DBA should have control on shrink, but with auto shrink you won’t be having control on database.
If you have a table with 50 gig and it’s got historical data and you don’t need any more in that database then you got go for truncate whole data in a table then it would be a good practice to shrink data file on that database, if log became huge and you don’t have any other option then you can shrink log but it is preferable to shrink manually
No comments:
Post a Comment