Archives: January 2016
Proper configuration of the TempDB system database is crucial for optimal performance of a SQL Server instances during heavy loads. The recommended strategy is to create multiple data files, one per CPU core (logical processor), but not more than 8. Those files should be equal in size and with the… Read more
It’s the first day of the year 2016 and I’m thinking about all the SQL events I attended in 2015.