• How It Works: Behavior of a 1 Trillion Row Index Build (Gather Streams from SORT)

    Posted 8 months ago
    by SQL Server Support Content}
    I ran into this behavior working on a 1 trillion row, spatial index build but the behavior can apply to any Gather Streams operator, retaining the sort order as rows pass though it.   I was just surprised a bit by the behavior until I dug deeper...

  • How to grab multiple parent/child elements from XML Data Source

    Posted 8 months ago
    by SQL Server Support Content}
    We had a question come up about why an XML query wasn’t pulling a 2nd Parent/Child element from the resulting data.  This was grabbing data off of a Web Service.  The example I was given was a public Web Service call for getting Weather information...

  • SharePoint Adventures : Using Claims with Reporting Services

    Posted 8 months ago
    by SQL Server Support Content}
    Back in February of 2011, I created a blog that walked through using Kerberos with Reporting Services . Since then, we have moved Reporting Services to a shared service within SharePoint.  This changes the game and we are now in the Claims world...

  • Version 9.04.0013 of the RML Utilities for x86 and x64 has been released to the download center

    Posted 8 months ago
    by SQL Server Support Content}
            X64 : http://download.microsoft.com/download/0/a/4/0a41538e-2d57-40ff-ae85-ec4459f7cdaa/RMLSetup_AMD64.msi X86 : http://download.microsoft.com/download/4/6/a/46a3217e-f523-4cc6-96e9...

  • RS, SharePoint and Forefront UAG Series – Intro

    Posted 8 months ago
    by SQL Server Support Content}
    I have been working a fairly complicated case over the last year that involved running Reporting Services Reports through a Universal Access Gateway (UAG) to publish a SharePoint Site.  I worked with an engineer (Alejandro Lopez) in the SharePoint...