Forum Replies Created

Viewing 15 posts - 3,046 through 3,060 (of 9,707 total)

  • RE: FCI and Availability Groups

    Kevin, thanks for the links. Now I have more questions.

    Is Primary Replica the database of origin or just the first replica that was set up?

    Per the above link:

    As soon...

  • RE: FCI and Availability Groups

    Perry Whittle (11/13/2014)


    Brandie Tarvin (11/12/2014)


    1) Both FCI and AG require windows clustering in order to work.

    Yes, both technologies require a functional Windows Server Failover Cluster.

    Note that you may also use...

  • RE: FCI and Availability Groups

    Shawn Melton (11/12/2014)


    I will say that PASS Summit 2014 aired a quick start to AlwaysOn that I found very useful to fill in these types of gaps, check it out...

  • RE: FCI and Availability Groups

    Steve Jones - SSC Editor (11/12/2014)


    I've got limited knowledge here, but AFAIK, the Windows Cluster moves over those items that are clustered in Windows, which could be SQL Server. If...

  • RE: FCI and Availability Groups

    TheSQLGuru (11/12/2014)


    Hey Brandie!! Please do make sure you REALLY know what your objectives/needs are and that you are doing things correctly to get you there. There are SOOO...

  • RE: Combining AlwaysOn Groups With Failover Cluster Instances

    I still need to re-read this article a few times to make sure I understand everything, but I do have one question after the first read through. When combining FCI...

  • RE: Odd Percentage on Estimated Execution Plan

    Thank you for the link, Grant. There are indeed a lot of variables in this proc. So it sounds like you've hit the nail on the head.

    I'll take a look...

  • RE: Questioning the effects of 100% CPU usage

    patrickmcginnis59 10839 (11/11/2014)


    Brandie Tarvin (11/11/2014)


    To clear up a misconception... we did stop the processes on the Test machine and I was immediately able to connect, as was the DBA sitting...

  • RE: Questioning the effects of 100% CPU usage

    To clear up a misconception... we did stop the processes on the Test machine and I was immediately able to connect, as was the DBA sitting next to me. Plus...

  • RE: Date Error

    You have two different date formats in your sample code. Unless you have a way for SQL to auto-identify which log strings contain which date formats, you're going to continually...

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (11/7/2014)


    Brandie Tarvin (11/7/2014)


    Can someone please help me here? I am having a very bad week, so I'm about to lose my temper with Stewart because he wants to...

  • RE: SSIS Execute Package Task Setup Question

    Koen Verbeeck (11/7/2014)


    Ah, so not a permission issue after all 😀

    I knew it wasn't. I just couldn't figure out how to create the correct connection manager. Now I'm kicking myself...

  • RE: SSIS Execute Package Task Setup Question

    Brandie Tarvin (11/7/2014)


    Koen Verbeeck (11/7/2014)


    Is the package stored on the machine itself, or on a UNC path?

    The package is stored on the machine itself under D:\SQLServer\MSSQL10\100\DTS\Packages\My Folder\. In Integration Services...

  • RE: SSIS Execute Package Task Setup Question

    Koen Verbeeck (11/7/2014)


    Does it already fail in BIDS?

    Yes. In fact, I haven't gotten past BIDS to running it from the GUI or a job. What I'm doing is running the...

  • RE: Are the posted questions getting worse?

    Can someone please help me here? I am having a very bad week, so I'm about to lose my temper with Stewart because he wants to focus on security issues...

Viewing 15 posts - 3,046 through 3,060 (of 9,707 total)