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...
  • Blog Post: Using Persisted Computed Columns in SQL Server Indexes

    As part of my research work, I generate thousands of simulations on an almost daily basis for various scenarios.  One of my scenarios involves determining strategies for selecting the most profitable short and long stock entry/exit positions.  Calculating this involves data mining stock history...
Page 1 of 1 (3 items)