I have a
SELECT INTO statement writing to a database which is in SIMPLE recovery mode, and is not tempdb. Will this use tempdb at all?
The SQL is something like
USE TGTDB GO SELECT * INTO DestinationTable FROM SRCDB.dbo.SourceTable GO
Will this use tempdb at all? We are running into contention issues.