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 » dmvs   (RSS)
  • Geek City: The Naming of Things

      As a teacher, and also a student of languages, one issue that’s always fascinating to me is how people choose to shorten a compound, or multi-part, name.  This is very problematic when the word is from another language.  For example, we use the word latte in English as a short form of caffè latte, but we shorten it to just the ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on May 27, 2016
  • Geek City: More statistics info available!

      I just started using a new DMV (one that’s actually an ‘F’ not a ‘V’, as in Function) that gives us more info about distribution statistics. It returns info about the last statistics update date (which is also available with a function STATS_DATE()). It also provides the number of rows sampled when the statistics were last updated. This is ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on April 9, 2013
  • Seeking Without Indexes

    A seek can contain one or more seek predicates – each of which can either identify at most one row in a unique index (a singleton lookup) or a range of values (a range scan).  When looking at a query plan, we will often need to look at the details of the seek operator in the Properties window to see how many operations it is performing, and ...
    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: Why I still need Sysprocesses

    I've said many times that my favorite new feature in SQL Server 2005 is the new metadata, in particular the new Dynamic Management Objects. When I have to do troubleshooting on a SQL Server 2000 system, it is worse than painful, not to have my favorite tools like sys.dm_tran_locks, sys.dm_exec_cached_plans andsys.dm_exec_query_plan. By now, on the ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on June 29, 2008
  • Did You Know? Fragmentation, revisited....

      A couple of questions arrived regarding my earlier post about fragmentation on the system tables, and since the questions really don't have anything to do with system tables, I felt they deserved a new post. 1) Using the DETAILED option includes the non-zero index-levels as well (non-leaf pages).  According to many source, this ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on February 28, 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
  • Geek City: HyperThreaded or Not?

    In almost all my classes, and every time I do any performance consulting, I get the question ''How can I determine if our SQL Server is hyperthreaded?'' I was delighted when I found the DMV sys.dm_sys_info, which has a column called hyperthread_ratio. But soon after, I read a blog post from one of my favorite SQL Server bloggers, Buck Woody who ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on December 8, 2007
  • Did You Know? The Best SQL Server 2005 Feature

    This post really should have a topic of ''Pet Peeve'' but I really didn't want to sound quite so negative. It seems like almost every time I see a clever solution in a newsgroup response, or in a blog post, about how to extract some very useful troubleshooting information using the Dynamic Management Views, someone will ask for an equivalent ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on December 5, 2007
Privacy Statement