Home Forums SQL Server 2008 SQL Server 2008 - General SQL Trace - simple SELECT shows writes RE: SQL Trace - simple SELECT shows writes
patrickmcginnis59
SSCertifiable
Points: 6483
More actions
August 29, 2012 at 9:24 am
#1531464
I'm guessing that your query made use of temp tables during its execution. That will generate some writes. I once filled up tempdb by executing a select top n * order by <some columns>. If your query is using a temp table, its going to write to it.