Home Forums SQL Server 2008 SQL Server 2008 - General TempDB questions RE: TempDB questions
bangsql
SSC Eights!
Points: 900
More actions
February 21, 2013 at 9:22 am
#1590033
1. any query uses group by , order by etc.. uses tempdb.
so if view contains that tempdb will use
2. no of physical cpu = no of tempdb files.