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?
Best Answer
SSMS query results cache to the C: drive by default. Go to Tool \ Options. See attached. Change this to another volume with more storage and you should be fine.