Tag Info

New answers tagged


When should I rebuild indexes? When the index fragmentation percentage is more than 30%. Is there a case for rebuilding indexes on a regular basis? There is no such case, but in general, doing Index Maintenance once in a week, over the weekend is the best practice to keep the environment stable. I would recommend using maintenance scripts from ...


There is NO NEED to run shrinkfile command after taking transaction log backup. What is the need of shrinking a log file which would eventually grow again? This is a blunder in my opinion considering the fact that you are doing it every day. Whenever the log file grows, transactions have to wait for this event to complete so SQL server becomes still until ...

Top 50 recent answers are included