Monthly Archives: January 2016

SQL Server 2014 TempDB Improvements

I am not sure how I missed this.  There is a performance improvement in TempDB in 2014. In summary, TempDB will be less aggressive writing to disk.  Here is the CSS page about it from April 2014.  https://blogs.msdn.microsoft.com/psssql/2014/04/09/sql-server-2014-tempdb-hidden-performance-gem/ Advertisements

Posted in Database Administration | Tagged , | Leave a comment