THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » metadata   (RSS)
Showing page 3 of 3 (25 total posts)
  • 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
  • Did you know? Cloning is Legal (and Available in SQL Server 2005)

      I first heard about the possibility of database cloning way back in version 7.0 and thought it sounded like a great idea. Who wouldn't love to have a bunch of identical little databases running around, of smaller size and easier manageability? Cloning a database means creating a statistics only copy of it, so that you can examine ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on November 21, 2007
  • Did You Know? What's a $ Worth?

      No, I'm not talking about US dollars, which are not worth much at all these days. I'm talking about the $ used in a particular construct in SQL Server 2005 to get information about a partition definition. There is a construct called $PARTITION which the BOL actually refers to as a function, but it doesn't act like any other function in the ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on October 13, 2007
  • Did you know? -- Better than sp_configure

    I’ve mentioned before that the new metadata is so voluminous that I’ve barely skimmed the surface. Last week in class in Minneapolis ( one of my students discovered an alternative to sp_configure. You’re probably aware that by default, even if you’re logged in as someone in the sysadmin group, you can’t see all the configuration ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on November 6, 2006
  • Did you know? -- Altering the length of a fixed-length column

    You may be well aware that if you alter the length of a column to a larger value, that SQL Server doesn’t go through all the rows at the time you issue the ALTER. The ALTER is a metadata only change, and the actual movement of data doesn’t happen until a row is updated. However, SQL Server does not reuse the original bytes in the row when a ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on October 13, 2006
Privacy Statement