Forum Replies Created

Viewing 15 posts - 496 through 510 (of 9,720 total)

  • RE: DbccLOBCompact on table with no LOB datatypes

    Jeffrey Williams 3188 - Monday, January 7, 2019 12:27 PM

    Here is a nice write up: https://sqlity.net/en/1051/blob-and-row-overflow-storage-internals-row-overflow-data/

    Even if you don't have LOB data...

    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.

    January 7, 2019 at 12:39 pm

    #2018217

  • RE: Does Stored Proc Complete if Machine Rebooted?

    It is possible that the client machine is being updated. Our workplace does that. In fact, corporate IT forcibly reboots EVERYONE's PCs on a nightly basis (or they did for...

    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.

    January 7, 2019 at 5:22 am

    #2018150

  • RE: Linked Server issue

    vivek52 - Wednesday, January 2, 2019 2:07 AM

    Hi..we are experiencing same sort of issue in our production environment. SQL job is getting...

    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.

    January 2, 2019 at 11:54 am

    #2017783

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

    Chris.null - Thursday, December 27, 2018 1:15 PM

    We are experiencing the same exact problem. I believe this issue was fixed with KB3152965. 

    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.

    December 31, 2018 at 11:40 am

    #2017668

  • RE: CASE to table conversion

    ScottPletcher - Friday, October 26, 2018 9:13 AM

    But it seems to me the real problem is that a simple code change...

    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 5, 2018 at 6:19 am

    #2012379

  • RE: CASE to table conversion

    Sue_H - Friday, October 26, 2018 11:06 AM

    I like the idea of decision tables. They are still around but I think...

    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 5, 2018 at 6:14 am

    #2012378

  • RE: Are the posted questions getting worse?

    GAH.

    I hate having a SSIS package fail and fail again when being run from a job, but works fine from the desktop. And I look and look and...

    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.

    October 26, 2018 at 6:16 am

    #2011314

  • RE: CASE to table conversion

    I'll look into decision tables. Thank you for the suggestion, Joe.

    Scott, I appreciate your input, but I want to make a non-code based solution if possible. The reason...

    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.

    October 26, 2018 at 5:16 am

    #2011311

  • RE: Are the posted questions getting worse?

    Am I really the only one annoyed by Mr. Ansi's "Please post DDL and follow ANSI/ISO standards when asking for help." response to the debate when the question didn't even...

    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.

    October 26, 2018 at 5:05 am

    #2011310

  • RE: NOT IN vs NOT EXISTS

    Thom A - Thursday, October 25, 2018 4:59 AM

    Perhaps my initial post mislead people, but the query in my initial post wasn't...

    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.

    October 25, 2018 at 5:11 am

    #2011109

  • RE: NOT IN vs NOT EXISTS

    Jeff Moden - Wednesday, October 24, 2018 6:04 PM

    Ask the ring knocker if he likes pork chops and then feed him your...

    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.

    October 25, 2018 at 4:48 am

    #2011099

  • RE: Are the posted questions getting worse?

    Lynn Pettis - Wednesday, October 24, 2018 2:17 PM

    Looks like I will be doing a deep dive to finally get my...

    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.

    October 25, 2018 at 4:40 am

    #2011097

  • RE: Are the posted questions getting worse?

    Lynn Pettis - Wednesday, October 24, 2018 1:54 PM

    Okay.  I had my annual review yesterday, and it was good.  Also had a...

    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.

    October 25, 2018 at 4:38 am

    #2011095

  • RE: Are the posted questions getting worse?

    Jeff Moden - Wednesday, October 24, 2018 11:30 AM

    Brandie Tarvin - Wednesday, October 24, 2018 11:24 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.

    October 24, 2018 at 11:42 am

    #2010982

  • RE: Are the posted questions getting worse?

    WHEE!

    Just got a text from my mom, who is watching the munchkin.

    Guess who just figured out how to do that silly clapping thing Mommy &...

    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.

    October 24, 2018 at 11:24 am

    #2010977

Viewing 15 posts - 496 through 510 (of 9,720 total)