Forum Replies Created

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

  • 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

  • Reply To: To Drop or Not to Drop (the temp table question)

    And finally other documentation has been supplied by the person who mentioned this to me:

    SQL Server Temporary Table Caching (mssqltips.com)

    Thank you everyone for your help. I appreciate 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.

    February 8, 2023 at 1:19 pm

    #4147047

  • Reply To: Are the posted questions getting worse?

    Looks like I woke everyone up this morning. Heeeheee.

    @=)

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

    #4147038

  • Reply To: Are the posted questions getting worse?

    Forget leading commas. Let's debate leading semi-colons. @=)

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

    #4147024

  • Reply To: Are the posted questions getting worse?

    Don't get me started in WITH (NOLOCK). Apparently there are a number of people suddenly making that recommendation to get rid of blocking.

    It's apparently easier advice to give people than...

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

    #4146705

  • Reply To: Are the posted questions getting worse?

    Phil: Someone told you that these temp table drops are expensive (in database terms), but without providing evidence, and now they're expecting you just to believe them?

    The burden of proof...

    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 7, 2023 at 5:11 pm

    #4146664

  • Reply To: To Drop or Not to Drop (the temp table question)

    Johan Bijnens wrote:

    This is the link holding the part that causes your confusion:

    Performance improvements in tempdb for SQL Server

    Thanks for the links. I will review.

    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 7, 2023 at 2:43 pm

    #4146584

  • Reply To: To Drop or Not to Drop (the temp table question)

    ScottPletcher wrote:

    I believe that SQL renames temp tables rather than dropping them, esp. for stored procs.  That way, when the proc runs again, it doesn't have to fully recreate 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.

    February 7, 2023 at 2:43 pm

    #4146583

  • Reply To: Are the posted questions getting worse?

    So, I could use some help on this one: To Drop or Not to Drop (the temp table question) – SQLServerCentral Forums

    I've tried Googling it but not finding exactly...

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

    #4146510

  • Reply To: Are the posted questions getting worse?

    I have been having the worst time with this website on my work PC for the past 9 months. Couldn't log in (and login screen looked weird). When I did...

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

    #4134696

  • Reply To: ERROR: Could not find a login matching the name provided

    Forgetting the domain was exactly the problem. Now we have an encryption message (the client isn't requesting encryption on encrypted database), but that's an entirely different issue.

    Thanks for the help!

    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.

    July 11, 2022 at 2:04 pm

    #4061658

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