Assume that you use Microsoft SQL Server 2012. When you perform select into temporary table operation, poor performance on I/O occurs in the system database tempdb.
The issue occurs because a select into temporary table operation causes eager write.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Article ID: 2958012 - Last Review: May 19, 2014 - Revision: 1