Browse by Tags

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 ...