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

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…