I am little bit confused about multiple tempdb files.
Suppose i want to place tempdb on its own disk of 100 gb, and want to set the size of tempdb to 100 gb. So in near future it probably do not need to autogrow. To impliment multiple tempdb file i.e. 8 (as per MS recommendation), because we have 4 quadra core
processor that is total 16 processors. So how to set size for 8 tempdb file.
Pl provide detail with step.
View Complete Post