• In SQL 2012, when wanting manually to shrink Tempdb, I go to the entry in Object Explorer (under Databases, System databases, TempdB), then right-click on TempdB and choose Tasks - Shrink - Database or File. It is a useful way round a re-boot of SQL when some code has ballooned this file, but obviously doesn't address the underlying cause.