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: The potential of SSD for millions of IOPS on increasingly larger databases

    NOTE: There is an update to this article at http://blogs.msdn.com/b/microsoftbob/archive/2010/11/08/pcie-ssd-update-optimizing-sql-backup-performance.aspx regarding the throughput I was able to achieve on my own configuration with the Fusion-io backup process.  Through some parameter changes on...
  • 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...
  • Blog Post: Cautions with Indexed Views

    If you’ve been following my blog, you may remember an article I did extolling the virtues of indexed views - http://blogs.msdn.com/microsoftbob/archive/2009/05/13/sql-data-warehousing-tip-2-indexed-views.aspx .  I stand behind that and have found this feature extremely useful.  In fact in my...
  • Blog Post: Some Uses for Query Hints

    Some of you are all set to flame me just because of my title. I know because a couple of years back, I would have probably been one of the first to say “NO!”, when anybody started talking about query hints. But, like everything else in this world, they have their place. First of all, I encourage you...
Page 1 of 1 (5 items)