Microsoft Bob

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

    Nested Identity Keys in SQL?

    • 0 Comments
    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...
  • Microsoft Bob

    A Wrapper for Running SQL Server 2008 Reporting Services Reports Anonymously

    • 3 Comments
    With SQL Server 2008, Microsoft re-architected SQL Server Reporting Services (SSRS) to no longer have an IIS dependency. It now relies directly on HTTP.SYS and handles web protocols independently. This is a good thing, in a lot of respects (see http:...
  • Microsoft Bob

    Cautions with Indexed Views

    • 0 Comments
    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...
  • Microsoft Bob

    Some Uses for Query Hints

    • 0 Comments
    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...
  • Microsoft Bob

    Getting the full exception from .NET

    • 0 Comments
    While we're on the topic of .NET coding, here's another technique.  If you thought my last post was short, here's an even shorter one... Ever wanted to make sure you returned an error message with all of the inner exceptions?  I know I've wasted...
  • Microsoft Bob

    Fun with Enums and a Generic File Date/Time Stamper

    • 0 Comments
    Time for a break from SQL stuff for a little .NET.  Have you ever wanted to use the integer value of an ENUM instead of the actual Enum Value?  For example, here is an enum I created to map datetime formats. public enum FileDatePrecision {...
  • Microsoft Bob

    Using NTILE with Cross Reference Values to Create Dimensions

    • 0 Comments
    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. ...
Page 1 of 1 (7 items)