• What is your opinion on how many TempDB files you should have?

    I know that it is best to have the TempDB on it's own LUN separate from all others.

    I have also read that you should create at least one TempDB database file per CPU core.

    What is your opinion on that?