Tag Info

New answers tagged


What factors will cause SQL Server to report different logical read counts for the same query in the absence of data writes? For a heap table, there's no mechanism I know of that would cause this. I notice that the author's reported logical reads only vary when compression was used. This suggests that the table rebuild was included on each execution. ...


https://social.msdn.microsoft.com/Forums/en-US/2a00c314-f35e-4900-babb-f42dcde1944b/dbcc-shrinkfile-page-411283400-could-not-be-moved-because-it-is-a-work-table-page?forum=sqldatabaseengine As proposed by Mike in the msdn forum , work tables are mostly associated with plan cache. Clearing them would remove the work table as well and then you may shrink ...

Top 50 recent answers are included