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: 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...
  • Blog Post: Using NTILE with Cross Reference Values to Create Dimensions

    I confess  lack of depth in SQL Analysis Services (SSAS).  I've read quite a bit about the capabilities including data mining, and played with a couple of the wizards, but just haven't had time to immerse deeply into end-to-end scenarios.  Based on that, I'm writing this post with a big...
  • Blog Post: Auto-Generating Pivot Views

    Coming back from the Sci-Fi world of AI, etc to some real world scenarios...  Earlier I posted a generic stored procedure that automatically unpivots data so that columns become rows.  Today, I provide the inverse capability, although not truly generic at this point, but the technique is generic...
  • Blog Post: Dumping SQL data in pivoted format

    Technorati Tags: SQL Server , Tips If you’re like me and spend a lot of time in SQL Query Analyzer, querying data directly, you may find the column display format tedious for tables with lots of columns or where you are only working with a couple of entries in the table anyways. Consider the following...
Page 1 of 1 (5 items)