Question of the day : Multiple tempdb data files will gain performance?


Do splitting tempdb data files according to the number of processors will gain performance improvement? I am more interested to hear about this.

Advertisements

Question of the day – Clearing tran_log


Do a full backup or differential backup will clear the tran_log?

I am interested to see your response and a justification for your answer is most accepted.

Answer(Posted on 19th May 2011) :

Let me come up with the answer of this question : No,fullbackup and differential backup wont clear the tran_log.A part of tran_log is backed up to ensure consistency,however the log is never cleared.

Tran_log backup in full recovery mode will ensure that your tran_log is truncated.