Introducing sp_CheckTempdb: Check Your SQL Server tempdb for Performance Issues

Free SQL Server DBA tool - sp_CheckTempdb

Most database folks might know the tempdb database in SQL Server is used for temporary tables, but many folks don’t realize all the other things that use this critical system database. It’s also used by table variables, cursors, aggregations, joins, and sorts. And by memory spills when you don’t have enough memory. And by integrity … Read more