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...

• This reply was modified 2 days, 4 hours ago by  Brandie Tarvin.

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...

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?

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

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...

• This reply was modified 5 days, 3 hours ago by  Brandie Tarvin.

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

• This reply was modified 5 days, 4 hours ago by  Brandie Tarvin.

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...

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 *...

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

• This reply was modified 5 days, 5 hours ago by  Brandie Tarvin.

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...

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...

• This reply was modified 1 month, 3 weeks ago by  Brandie Tarvin.

Following up on this... Will it hurt if I remove system object permissions from the public role?

Or, alternatively, is there a method to ensure that I only remove user objects...

No, it was definately object-level permissions on the public role. I revoked them and my regular account no longer could see the database data.

I'm assuming that it only showed for dbo because it was in public. Because it didn't show for dbo on other databases.

The script I should have used is below:

            
October 1, 2024 at 8:03 pm
            
#4464324

            
            
                                                
        

Oh, good grief. My check on public securables finally loaded (I had turned away from it and forgotten to close it after taking that screenshot). Apparently it is public, not...