Browse by Tags

• fragmentation
• metadata
• storage
• temp tables
• tempdb

• 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 Read More... Posted Wednesday, November 26, 2008 10:08 AM by Kalen Delaney | 6 Comments Filed under: internals, storage, temp tables, DMVs, tempdb

• Geek City: Fragmentation on the System Tables

  It's my first post of the new year. I hope it's starting out well for all of you! New year, but sometimes the same old questions. I got another email asking about defragging the system tables. It seems to be in the Hit Parade of FAQs. First of all, WHY Read More... Posted Thursday, January 17, 2008 6:05 PM by Kalen Delaney | 4 Comments Filed under: internals, metadata, DMVs, fragmentation