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

In my previous post, I mentioned that it is important to understand the difference between estimated and actual query plans, so I decided to go into a few more details regarding the differences. Optimization takes place before execution, so in one sense, Read More...