I'm inserting over 10 million rows into a temp table and its size is about 5GB. My computer has 32GB of RAM. Does SQL Server put this table in RAM or on the disk?
I'm inserting over 10 million rows into a temp table and its size is about 5GB. My computer has 32GB of RAM. Does SQL Server put this table in RAM or on the disk?