Forum Replies Created

Viewing 15 posts - 61 through 75 (of 9,720 total)

  • Reply To: Microsoft Recommendations for Update Stats?

    Wow. Just ... WOW. Watched the 1.2. Now going to watch 3.

    Thanks, Jeff.

    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 8:07 pm

    #4489015

  • Reply To: Microsoft Recommendations for Update Stats?

    So I am doing some major learning today. And here I thought I could take it easy on the week of Turkeys! @=)

    Thank you both. I have already forwarded 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.

    November 25, 2024 at 3:51 pm

    #4488912

  • Reply To: Microsoft Recommendations for Update Stats?

    Oh, and can I get a favor? Can everyone to update their posts with the proper spelling of my name? Brandie.

    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 3:03 pm

    #4488901

  • Reply To: Microsoft Recommendations for Update Stats?

    Jeff, thank you for that information. I will research.

    So we are using the Hallogren solution for index maintenace and yes, it involves reorgs. I removed reorgs from the servers I'm...

    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 3:02 pm

    #4488900

  • Reply To: Microsoft Recommendations for Update Stats?

    Jo, I have already read through both links you have provided in this chat. I am looking for white papers beyond this information.

    EDIT: The application team member was very specific...

    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 22, 2024 at 4:13 pm

    #4487823

  • Reply To: Microsoft Recommendations for Update Stats?

    Michael L John wrote:

    Stop rebuilding indexes.

    Microsoft's documentation states:

    Index maintenance decisions should be made after considering multiple factors in the specific context of each workload, including the resource cost of maintenance. They should...

    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 22, 2024 at 4:07 pm

    #4487822

  • Reply To: Microsoft Recommendations for Update Stats?

    Thank you, everyone, for your input.

    Now would a high-volume OLTP (lots of daily inserts or deletes or both) make a difference in your opinion?

    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 22, 2024 at 3:57 pm

    #4487821

  • Reply To: Are the posted questions getting worse?

    Wondering if anyone has time to point me to resources regarding this particular question: Microsoft Recommendations for Update Stats? – SQLServerCentral Forums?

    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 21, 2024 at 3:34 pm

    #4487330

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

    I'm sorry. The post that was previously here was harsh. I am removing it because there was no call for me to sound so short.

    Converting to uniqueidentifier did not work...

    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 19, 2024 at 5:07 pm

    #4486076

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

    Kaj, that does work faster than the function I found via Google. THANK YOU SO MUCH!

     

    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 19, 2024 at 4:44 pm

    #4486058

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

    kaj wrote:

    There isn't really a need to use that scalar function for the conversion.

    This will also work:

    SELECT t.SPID, t.Status, t.ProgramName, j.name AS JobName
    FROM @Table t
    LEFT OUTER JOIN...

    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 19, 2024 at 4:40 pm

    #4486057

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

    Ant-Green wrote:

    You could just do a straight select also, no need to convert the hex to the GUID as it will implicitly do this for you

    SELECT *...

    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 19, 2024 at 4:25 pm

    #4486032

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

    Weird gateway error caused repost. And won't let me delete the code block.

    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 19, 2024 at 3:18 pm
     
    #4485992
         
     
    •  
  •  
     
     Reply To: Converting job_id to join to another table. 
     
       
    And after changing my search terms in Google to "SQL Server get job name from sp_who2 program_name" instead of something more generic, I HAVE FOUND IT!
    CONVERT(VARCHAR(34),master.dbo.fn_VarbinToHexStr(sj.Job_ID))
    This function converts jobID to...
    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 19, 2024 at 3:17 pm
     
    #4485991
         
     
    •  
  •  
     
     Reply To: Object-level permissions on dbo 
     
       
    Oh, nevermind. I think I found it. WHERE sys.objects.object_id > 0 AND sys.objects.object_id < 1042102753.
    Let me know if anyone knows of any other method.
    EDIT: Hrm. Nope. Not quite the solution...
    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 4, 2024 at 2:15 pm
     
    #4465314
         
     
    •  
 
Viewing 15 posts - 61 through 75 (of 9,720 total)