I'm quite new to SQL Server 2012, I would be grateful if someone can help. I have restored a copy of a huge database to SQL Server 2012 and I tried to run some simple queries against it.
I'm trying to run a SELECT query against a database table of
136898115 lines. This
SELECT query only has a simple
WHERE clause. Every time I run this query, it fails because the system disk (the partition where Windows is installed -
C:\) run out of space (this partition has only 6GB free space), and I don't understand why. I defined my tempdb to be on a different drive, which has more than 14 terabytes of free space. Of course that my database is located on a different drive too.
What makes my system partition run out of space? Is it the page file?