Forum Replies Created

Viewing 15 posts - 3,061 through 3,075 (of 9,720 total)

  • RE: Questioning the effects of 100% CPU usage

    The argument appears to be won without the expected inkshed and tantrums. The Dev in question has fixes for the issue.

    YAY!

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    November 14, 2014 at 11:49 am

    #1758705

  • 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?

    TheSQLGuru (11/13/2014)

    http://technet.microsoft.com/en-us/library/ff878253(v=sql.110).aspx

    Per the above link:

    As soon...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    November 14, 2014 at 11:44 am

    #1758704

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    November 13, 2014 at 10:56 am

    #1758338

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    November 13, 2014 at 5:33 am

    #1758198

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    November 13, 2014 at 5:30 am

    #1758197

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    November 13, 2014 at 5:27 am

    #1758194

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    November 12, 2014 at 10:12 am

    #1758035

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    November 12, 2014 at 6:43 am

    #1757970

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    November 11, 2014 at 8:34 am

    #1757702

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    November 11, 2014 at 5:54 am

    #1757664

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    November 10, 2014 at 12:06 pm

    #1757522

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    November 7, 2014 at 7:05 am

    #1757202

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    November 7, 2014 at 7:02 am

    #1757200

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    November 7, 2014 at 6:39 am

    #1757193

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    November 7, 2014 at 6:35 am

    #1757190

Viewing 15 posts - 3,061 through 3,075 (of 9,720 total)