THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » DMVs » temp tables » storage   (RSS)
  • Geek City: Space Used By Worktables

    Today, a reader asked me the following: ''How can I find the amount of space occupied by a worktable?. Using SET STATISTICS IO ON, I can only see the number of reads using the worktable, not the amount of space taken.'' What is a worktable? I always like to think of it as a temp table that SQL Server builds without being asked. While ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on November 26, 2008
Privacy Statement