Forum Replies Created

Viewing 15 posts - 151 through 165 (of 9,720 total)

  • 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

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

    Yes and no. The user sent me screenshots of a different login that worked and getting information from him last week was like trying to chase a cat through an...

    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 1:30 pm

    #4061630

  • Reply To: Are the posted questions getting worse?

    Dare I ask what happened Saturday that has everyone in a tizzy? As I was paying attention to family and not work or the news.

    Also, got a SQL 2017 error...

    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 12:38 pm

    #4061618

  • Reply To: Are the posted questions getting worse?

    Michael L John wrote:

    Is anyone using Idera's SQL Compliance Manager, or something similar?  Auditing requests from our clients is becoming a hot topic.  Some of these are kind of ridiculous, but hey,...

    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 26, 2022 at 7:57 pm

    #4039875

  • Reply To: Are the posted questions getting worse?

    Okay, this is VERY weird. My last post, when I hit submit, errored out with "Are you sure you want to do that?"

    And when I hit submit again, it accepted...

    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 26, 2022 at 12:34 pm

    #4022426

  • Reply To: Are the posted questions getting worse?

    So I'm updating my internal-to-the-business resume and I'm trying to figure out the best way to spell out "one-stop shop" without actually using those words. How else, in formal /...

    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 26, 2022 at 12:33 pm

    #4022425

  • Reply To: Are the posted questions getting worse?

    Thom A wrote:

    Out of interest, has anyone heard or seen from Gail in awhile? I haven't seen them about in ages. I noticed that their website has been down a little...

    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 14, 2022 at 11:24 am

    #4015602

  • Reply To: Powershell calling GPG fails on SQL Job

    So it turns out that I needed to reboot the servers because nothing was recognizing that GPG had been installed. GPG didn't say anything about needing a reboot, but once...

    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 26, 2022 at 12:44 pm

    #4006337

  • Reply To: Are the posted questions getting worse?

    Anyone have powershell / SSIS with GPG experience? I could use some help here: https://www.sqlservercentral.com/forums/topic/powershell-calling-gpg-fails-on-sql-job

    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 18, 2022 at 3:47 pm

    #4001967

  • Reply To: Are the posted questions getting worse?

    So I can't use QUOTE in IE and the website isn't readable to me (nor will it let me log in) using Edge or Chrome... Fun stuff.

    Anyway... Steve Jones wrote:

    >>FYI:...

    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, 2022 at 6:21 pm

    #3981578

  • Reply To: SQL Server Policy Support Mail Profile

    After looking at this more carefully, I realized I was looking at accounts not profiles. When I look at the profiles, I think these were something set up by 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 4, 2022 at 11:39 am

    #3980693

Viewing 15 posts - 151 through 165 (of 9,720 total)