THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Internals » DMVs » 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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement