bangsql (2/21/2013)
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.
RAM is also used first for grouping or sorting when possible. Only if RAM available to that query is insufficient is tempdb used to do grouping and sorting.
SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.