Pages

Wednesday, August 21, 2013

SQL SERVER – Performance Optimization of SQL Query and FileGroups | Journey to SQL Authority with Pinal Dave

It is suggested to place transaction logs on separate physical hard drives. In this manner, data can be recovered up to the second in the event of a media failure. In SQL 2005 When database is created without specifying a transaction log size, the transaction log will be re-sized to 25 percent of the size… Continue Reading...

Source: SQL SERVER – Performance Optimization of SQL Query and FileGroups | Journey to SQL Authority with Pinal Dave