Microsoft Bob

NOTE: The views expressed on this blog are my own and may not reflect the views of Microsoft

Browse by Tags

Tagged Content List
  • Blog Post: Back again, Dealing with Storage-aligned Index oddities

    I’m back after being on leave for past several weeks in case you wonder why I haven’t posted. To quote Joy Gresham from the move ShadowLands “I wasn’t dead, I was just in America (fill-in-the-blank)” This was one of my favorite movies that had so many wonderful quotes (...
  • Blog Post: Nested Identity Keys in SQL?

    This weekend I played with partitioning.  I have a table with about 10 million rows spanning the last 6 years of stock history for AMEX, NYSE, Indexes, and NASDAQ.   I partitioned each year into a separate filegroup so that should make it much easier to purge archive the old years and...
Page 1 of 1 (2 items)