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   (RSS)
  • Seeking Without Indexes

    This article has permanently moved to https://sqlkiwi.blogspot.com/2011/02/seeking-without-indexes.html
    Posted to Page Free Space (Weblog) by Paul White on February 17, 2011
  • 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
  • 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 do you think you would need to defrag a system table? Fragmentation is only a problem when you ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on January 17, 2008
Privacy Statement