Forum Replies Created

Viewing 15 posts - 46 through 60 (of 9,720 total)

  • Reply To: Are the posted questions getting worse?

    Sooooooo.... something weird is happening on another thread, one I started. Converting job_id to join to another table.

    I had a long PTO break over the holiday, came back 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.

    January 7, 2025 at 12:57 pm

    #4511405

  • Reply To: Converting job_id to join to another table.

    This is weird. While I was on PTO, I received notification from someone replying to this thread but when I look at this thread, the reply isn't here.

    To be clear...

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

    #4510819

  • Reply To: Are the posted questions getting worse?

    David Burrows wrote:

    Jeff Moden wrote:

    Brandie Tarvin wrote:

    Eirikur Eiriksson wrote:

    Does anyone have an idea for RPO 😉

    Return Porkchop Output

    EDIT: Or Rebounding Porkchop Objective?

    Raw Porkchop Onslaught

    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.

    December 17, 2024 at 12:25 pm

    #4499560

  • Reply To: Are the posted questions getting worse?

    Michael, I feel your pain. I hope Santa brings you a large porkchop launcher to suitably admonish all involved.

    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 17, 2024 at 12:22 pm

    #4499559

  • Reply To: Are the posted questions getting worse?

    Radish Parsnip Orecchiette.

    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 16, 2024 at 7:38 pm

    #4499236

  • Reply To: Are the posted questions getting worse?

    Eirikur Eiriksson wrote:

    Does anyone have an idea for RPO 😉

    Return Porkchop Output

    EDIT: Or Rebounding Porkchop Objective?

    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 16, 2024 at 6:52 pm

    #4499212

  • Reply To: Are the posted questions getting worse?

    Interviewing for open position...

    My boss: Rate your SQL skills & knowledge on a scale of 1 to 10.

    Interviewee: 7 or 8

    Me: Let's talk about backups and restores.

    Interviewee: I have 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.

    December 16, 2024 at 12:39 pm

    #4499031

  • Reply To: Blob Storage automated downloads

    Grant Fritchey wrote:

    Just know that moving data OUT of Azure costs money.

    I thought just LOOKING at Azure cost money! @=)

    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 5, 2024 at 6:16 pm

    #4493803

  • Reply To: Blob Storage automated downloads

    Thanks, Everyone. Sorry for the slow response. I've been slammed with last moment of the year work.

    Steve, even Microsoft stuff has to go through a testing / peep process here....

    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 5, 2024 at 6:12 pm

    #4493802

  • Reply To: Converting job_id to join to another table.

    Dup post

    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 5, 2024 at 6:08 pm

    #4493799

  • Reply To: Converting job_id to join to another table.

    So to clarify a few things, I used sp_who2 as an example anyone could do. What is really happening is we are logging trace data on blocking events and long-running...

    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 5, 2024 at 6:06 pm

    #4493797

  • Reply To: Are the posted questions getting worse?

    So on a whim (because health insurance is going to make me take a paycut next year even if I get a raise), I started checking out salary info 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.

    December 5, 2024 at 5:53 pm

    #4493773

  • Reply To: To View or not to View, that is the question...

    I'm a little late to the party, but I have plenty of horror stories about nested views. Mostly for the reasons Jo mentions but also troubleshooting problems is a major...

    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 25, 2024 at 9:39 pm

    #4489048

  • Reply To: Compare rows within the same table

    So I'm a big fan of SARGability, which means I would take Scott's version and do it with a CTE.

    WITH JobTypes AS (SELECT JobID, MAX(CASE WHEN TaskName...

    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 25, 2024 at 9:28 pm

    #4489036

  • Reply To: Microsoft Recommendations for Update Stats?

    Now watching Black Arts # 3 and I just have to ask..

    Jeff, where do we get your f'n Tally Function. @=) (j/k).

    But on a serious note, do you have 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.

    November 25, 2024 at 9:19 pm

    #4489034

Viewing 15 posts - 46 through 60 (of 9,720 total)