Viewing 15 posts - 16 through 30 (of 38,242 total)
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...
May 18, 2022 at 3:24 pm
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...
May 18, 2022 at 2:00 pm
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...
May 18, 2022 at 1:33 pm
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...
May 18, 2022 at 1:28 pm
No, no rights are set. You must configure the rights on the remote database.
May 18, 2022 at 11:47 am
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...
May 18, 2022 at 10:54 am
Hard to tell without code and output given.
May 18, 2022 at 10:45 am
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...
May 18, 2022 at 10:43 am
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...
May 18, 2022 at 10:09 am
Please don't cross post.
Replies here: https://qa.sqlservercentral.com/forums/topic/sql-filestream-concurrency-support-2
May 18, 2022 at 9:36 am
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?...
May 17, 2022 at 2:41 pm
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...
May 17, 2022 at 12:39 pm
happy to help. A common mistake that people make.
May 17, 2022 at 10:46 am
Couple things. Is port 1434 opened for UDP or TCP? The former is needed.
If you get the port for the named instance, can you connect remotely? This is in the...
May 16, 2022 at 3:04 pm
That's a good test. Did the person with the cert try anything outside of the training? Did they actually write their own trigger or just read about how they work?
Those...
May 16, 2022 at 3:02 pm
Viewing 15 posts - 16 through 30 (of 38,242 total)