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 » partition functions   (RSS)
  • Geek City: My Big Fat Partitioning Query

    When SQL Server first introduced table and index partitioning in SQL 2005, it was the same version that all the metadata changed. So I decided that I could learn a lot about metadata and a lot about the organization and storage of partitions if I tried to write a query, and then a view, that included almost everything anyone would ever need to ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on July 26, 2010
  • Geek City: ALTERing a Partition Function

    Finally, a real geeky post. I received two questions in as many weeks about what really happens to existing partitions when you alter the underlying partition function. The big question being… does altering a partition function cause any data movement? The answer, as usual, is “It depends” Most people who work with partitioning are aware that the ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on August 16, 2009
  • 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
Privacy Statement