Forum Replies Created

Viewing 15 posts - 1,096 through 1,110 (of 9,715 total)

  • RE: Are the posted questions getting worse?

    Ahhh. I love it when I can reuse code I wrote for an article when I have an urgent thing to fix in my environment. No writing the code from...

    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.

    March 20, 2017 at 4:54 am

    #1933958

  • RE: Are the posted questions getting worse?

    I use nodes because usually we're looking for specific values. Nodes works great if you need a WHERE clause to search the XML. But I'll be honest, I haven't played...

    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.

    March 20, 2017 at 4:49 am

    #1933955

  • RE: Detective Stories - Tracking Down the Database's Dependents Part 2

    John Hick-456673 - Friday, March 10, 2017 2:37 PM

    Thank you for sharing this.  I would personally add one more step to this...

    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.

    March 20, 2017 at 4:27 am

    #1933953

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 - Friday, March 17, 2017 11:13 AM

    I tend to be more interested in ideas and correct code than perfect English.
    Some...

    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.

    March 17, 2017 at 11:36 am

    #1933814

  • RE: HELP! Why did a restart improve performance?

    TheSQLGuru - Thursday, March 16, 2017 8:26 AM

    Brandie Tarvin - Thursday, March 16, 2017 4:35 AM

    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.

    March 16, 2017 at 12:26 pm

    #1933603

  • RE: Are the posted questions getting worse?

    Lynn Pettis - Thursday, March 16, 2017 9:57 AM

    Need a cancel button when you want to cancel from a reply when you...

    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.

    March 16, 2017 at 10:32 am

    #1933548

  • RE: Are the posted questions getting worse?

    Sigh. So my morning starts off with a Dev asking me to move code that includes some interesting data type definitions... FLOAT (without scale and precision) and VARCHAR(04) or VARCHAR(025)....

    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.

    March 16, 2017 at 5:16 am

    #1933428

  • RE: HELP! Why did a restart improve performance?

    Can I just mention that having a Test database on the same server as a Production database (whether or not they are on the same instance) is a Really Bad...

    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.

    March 16, 2017 at 4:35 am

    #1933424

  • RE: remove a listener IP from a SQL Availability Group Listener

    Database admin(DBA) - Wednesday, March 15, 2017 11:49 PM

    Hi All,
    I have an availability group that was a multiple subnet     over multiple...

    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.

    March 16, 2017 at 4:31 am

    #1933423

  • RE: Availability Groups Removed & Readded Database Problem :exclamation:

    Talib123 - Thursday, March 16, 2017 4:00 AM

    Have you turned off the T-LOG backup job while trying to sync. This can cause...

    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.

    March 16, 2017 at 4:25 am

    #1933421

  • RE: Availability Groups Removed & Readded Database Problem :exclamation:

    Ricky Valencia - Monday, March 13, 2017 9:00 PM

    Brandie Tarvin - Monday, March 13, 2017 11:41 AM

    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.

    March 16, 2017 at 4:23 am

    #1933419

  • RE: Availability Groups Removed & Readded Database Problem :exclamation:

    Sigh. After all the futzing, it looks like my only option is to take another FULL backup with a TLOG afterwards, then restore those and hope it works this time.

    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.

    March 13, 2017 at 2:17 pm

    #1932957

  • RE: Availability Groups Removed & Readded Database Problem :exclamation:

    Henrico Bekker - Monday, March 13, 2017 11:52 AM

    Sounds strange.
    Test one server by deleting the secondary and populating it from 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.

    March 13, 2017 at 12:02 pm

    #1932934

  • RE: Are the posted questions getting worse?

    I could use some help with Availability Groups if anyone has time to take a peek.

    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.

    March 13, 2017 at 11:43 am

    #1932927

  • RE: Making Process Changes

    Given your reply, it makes sense to batch reports that are logically close to each other, but I would still look at (if you can) report size and use that...

    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.

    March 10, 2017 at 4:27 am

    #1932671

Viewing 15 posts - 1,096 through 1,110 (of 9,715 total)