I've seen plenty of people think this. It's why I wrote an article demonstrating this isn't the case.

That's interesting. I only see one page there, with 15 posts displayed. How many posts are on the page for you?

https://www.sqlservercentral.com/forums/topic/disabling-backup-jobs

 

I don't see this as a problem, but I am welcome to a URL and browser that might have an issue. I see this, logged in or not.

May 24, 2022 at 9:21 am

#4038101

This is really no different than inserting into a SQL Table. You can have blocking/delays with concurrency with multiple people inserting to the same page.

With FS, you have to ensure...

All depends on the job. as I've built horse feeders, driving 30-40 screws into 2by material, an impact driver is a necessity. Doing stuff inside the house, hand tools work...

You're using some strange verbiage. Extend the API. Do you mean have more clients calling this stored procedure? However you call these isn't relevant, so saying you are extending your...

I think it's more a "is there a better way to do this?" question.

Do you use a screwdriver, a Philips bit in a drill or an impact driver? Yes, depending...

No, no rights are set. You must configure the rights on the remote database.

HASHBYTES returns a set size, as Jeff noted. The inputs can be varchar(max), so you'd need to ensure that the first input is cast to varchar(max) to ensure this returns...

Hard to tell without code and output given.

Which user? Do you mean the user that you specify as the credential when you create the linked server? This is a credential on the remote database that you have...

It's not quite clear what you mean by API and what you're doing with FileStream (FS).

 

This is designed to give concurrent access to blob items at a higher rate than...

Please don't cross post.

Replies here: https://www.sqlservercentral.com/forums/topic/sql-filestream-concurrency-support-2

How are the jobs structured? If you are looking for a specific db, is this because you don't care about some, or you really need to know whether to respond?...

You would have a job that runs something like this:

SELECT sj.name
   , DATEDIFF(MINUTE, sja.start_execution_date, GETDATE()) AS MinuteExecuting
   , sja.start_execution_date
FROM msdb.dbo.sysjobactivity AS sja
INNER JOIN...