Forum Replies Created

Viewing 15 posts - 121 through 135 (of 295 total)

  • RE: Ordered Data

    Yet another great question that required some digging to ensure the correct answer...

    Referencing BOL

    The Stream Aggregate operator requires input ordered by the columns within its groups. The optimizer will...

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • RE: What is a Database Administrator today?

    Outer World (12/8/2013)


    I worked for the business unit (BU) and not the IT department, so I was not granted SysAdmin rights to the servers even though my position was...

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • RE: Windowing Ranges

    Good question, took a bit of research to make sure I was correct, but got there in the end.

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • RE: SQLServerCentral apologizes and you can win a book

    Great to see SSC call out and apologize for the plagiarism, but how about the culprit (Kamil Moscicki) stand up and do the right thing and apologize not only to...

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • RE: Clustering on different subnets with AlwaysOn added on the top of it.

    Okay, I just see DR as part of production.

    You can install a second instance on the DR site (and not part of the DR SQL Cluster) and as long as...

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • RE: Clustering on different subnets with AlwaysOn added on the top of it.

    So you want your pre-production environment to exist on your production environment ? Why ?

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • RE: Clustering on different subnets with AlwaysOn added on the top of it.

    I have just completed a very similar build - Windows 2012 R2 Core and SQL Server 2012.

    What you want to do is to add a listener across Multiple Sub-nets:

    1.With...

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • RE: sysadmins

    nice Q, thanks

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • RE: SSIS Variable Casting

    Good question - thanks.

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • RE: Wildcards

    Nice straight forward question. Thanks

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • RE: PIVOT Me

    Koen Verbeeck (11/17/2013)


    Nice question, thanks.

    +1

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • RE: Computed columns Data Types

    Good Q, thanks.

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • RE: Data Compression

    As been pointed out Enterprise has every feature, and developer & evaluation have the same features as Enterprise. so there is more than one answer..... flawed question.

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • RE: SSRS Query with hyperLink

    Alan.B (11/12/2013)


    It sounds like you are trying to do a drill-through report. This should get you started:

    Drillthrough Reports (Report Builder 3.0 and SSRS)

    Appreciate the point in what looks the right...

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • RE: Automatic Page Repair

    SQLRNNR (11/11/2013)


    Thanks. Straight forward enough of a question.

    +1

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

Viewing 15 posts - 121 through 135 (of 295 total)