[dba-SQLServer] log file size

Stuart McLachlan stuart at lexacorp.com.pg
Fri Oct 5 17:12:26 CDT 2012


Fragmentation is not a problem with SSD disks.   Go ahead and shrink the data files.

(google "SSD fragmentation")

-- 
Stuart

On 4 Oct 2012 at 14:49, jwcolby wrote:

> I pretty much come along behind and shrink the logs after major update operations.  I have been told 
> to never shrink the data files because to do so fragments them so I do this 'data migration' process 
> 
> John W. Colby
> Colby Consulting



More information about the dba-SQLServer mailing list