Forum Replies Created

Viewing 15 posts - 136 through 150 (of 9,725 total)

  • Reply To: Are the posted questions getting worse?

    Sigh. Nope. We should be managing dirty reads on the statement level - not the session level - because apparently there may be some statements in a stored procedure 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.

    August 23, 2023 at 4:39 pm

    #4269305

  • Reply To: Are the posted questions getting worse?

    Jeff Moden wrote:

    Thom A wrote:

    As we're sharing "new job" pains, we're likely going to be are taking responsibility of IT services for our parent company in the month months (years).

    Ok... let's...

    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.

    August 23, 2023 at 4:16 pm

    #4269300

  • Reply To: Are the posted questions getting worse?

    Hey, binary still has legs on it!

    @=)

    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.

    August 23, 2023 at 1:25 pm

    #4269136

  • Reply To: Are the posted questions getting worse?

    So I haven't been able to consistently post for a while because stupid issues with website or browser (not sure which, but I didn't actively change anything). And now 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.

    August 23, 2023 at 12:27 pm

    #4269066

  • Reply To: Are the posted questions getting worse?

    jonathan.crawford wrote:

    Trying to imagine a scenario where I worked with Jeff Moden and tried to call out his code...

    Jeff, Tally tables aren't working and this RBAR thing is RIDICULOUS. No...

    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.

    August 23, 2023 at 12:21 pm

    #4269065

  • Reply To: Are the posted questions getting worse?

    Jo Pattyn wrote:

    It's getting popular to rename brands

    I am not using that silly new name for The Platform Formerly Known as Twitter.

    YAY! Website...

    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.

    August 23, 2023 at 12:18 pm

    #4269064

  • Reply To: SSISDB and availability groups problem

    I'm not sure. I wasn't the person who did the original server move / install. I will go back and check, though. Thank you for this information.

    A brief glance at...

    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.

    May 19, 2023 at 2:30 pm

    #4193080

  • Reply To: Are the posted questions getting worse?

    Well, my workplace desktop support is useless on the SSC website issue. I am the only person in the office having problems with it but apparently the issue is SSC....

    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.

    May 18, 2023 at 9:26 pm

    #4192558

  • Reply To: Looking for recompiling stored procedures

    I have not. But don't they have to be set up in advance?

    I found something about SQL Profiler / server trace and perfmon as well, but again, stuff that needs...

    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.

    April 11, 2023 at 11:09 pm

    #4172533

  • Reply To: Transaction has no commit error

    Well, I just encountered victory of a sorts. After I pushed back and told the Dev this didn't make sense that the two issues were connected, he managed to find...

    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 9, 2023 at 7:09 pm

    #4158984

  • Reply To: Cannot bulk load because the file could not be opened error

    Ha. I think you're right. NLTM is the method.

    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 8, 2023 at 6:23 pm

    #4158288

  • Reply To: Transaction has no commit error

    I want to point out this part of the code:

       SET @TSql = N'INSERT INTO dbo.PR_Archive  
       SELECT * FROM OPENQUERY([LinedServer],''SELECT Col1,...

    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 8, 2023 at 1:28 pm

    #4158169

  • Reply To: Transaction has no commit error

    My apologies for the mistype on OpenQuery. I spent all day querying stuff with a lot of underscores in the name. I think my fingers just defaulted to that without...

    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 8, 2023 at 1:26 pm

    #4158168

  • Reply To: Cannot bulk load because the file could not be opened error

    The SPN thing is a definite possibility, but why would the test NAS work but the QC NAS not work on the QC server?

    That's what is driving me nuts. One...

    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 8, 2023 at 12:55 pm

    #4158162

  • Reply To: Are the posted questions getting worse?

    Talking about ChatGPT, has anyone seen this one yet? https://www.cnn.com/2023/02/08/tech/google-ai-bard-demo-error/index.html

    <headdesk>

    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.

    February 9, 2023 at 1:14 pm

    #4147514

Viewing 15 posts - 136 through 150 (of 9,725 total)