Viewing 15 posts - 76 through 90 (of 1,626 total)
Yes, dev and test servers hitting the same end point for the services, but the web services are hosted on two web servers, one is for dev web server, the...
August 18, 2021 at 12:21 am
unfortunately it is not something simple that T-SQL can handle. There are complicated logic to calculate stop corners according to time and direction of the bus etc, that is why...
August 18, 2021 at 12:15 am
SSIS only has one execute task that calls the web service. I run today, there are 2000 routes to process, it runs about 8 hours on dev, and 10 hours...
August 17, 2021 at 11:16 pm
I did see in the .net code the route list is passed in batch to the application, but when it process detailed information in each route, it has to process...
August 17, 2021 at 10:27 pm
All the steps in ETL runs pretty quick except this only task called execute process task which calls a web application .exe which is a wrapper that actually called vendors...
August 17, 2021 at 7:54 pm
Yes, I did analyze the execution log, the slowess happened on each route processed for each stop location.
August 17, 2021 at 6:52 pm
all this web service is to process each route one by one for stops and students, and street corners. After one route, process another one. It repeats same process for...
August 17, 2021 at 6:31 pm
Thank you, yes option 1 is my preferred too, thanks for explaining that clearly.
May 15, 2021 at 9:02 pm
Thank you, yes, I get to know sysprosses result the same as sp_who2.
But if I run sp_whoIsActive, I click during the lastbatch time, but no records shows.
So I am wondering...
May 15, 2021 at 12:24 am
Thank you,
Is this the one for CU8 thanks,
on this page https://www.catalog.update.microsoft.com/Search.aspx?q=sql%20server%202019
on Steve's page:
May 12, 2021 at 4:26 pm
Could you please explain what this part mean?
cross apply (values (charindex(',', string),
len(string))) st(cloc, lng)
also can the cross apply replace with inner join?
thanks
April 24, 2021 at 4:19 pm
Thank you so much, that works.
But I need to understand this more, esp, those functions and cross apply. Will come back with questions.
April 24, 2021 at 3:57 pm
Thanks. The reason we want to do this is to update firstname, middle and last name in a table with the displayname in active directory. but in active directory the...
April 23, 2021 at 4:45 pm
Thanks, what does st(cloc, lng) mean?
I join with my table, but it says 'Incorrect syntax near 'st'.'
SELECT employeeID
,DisplayName
, lr.l fname, calc.lname, calc.m_init
FROM dbo.ADStaff a
cross apply (values (charindex(',', DisplayName,
len(DisplayName))) st(cloc, lng)
cross...
April 23, 2021 at 2:20 am
Thanks, Of course I can just back the log up, and do the full backup.
My question for this post is try to figure out what is the reason to do...
March 30, 2021 at 7:57 pm
Viewing 15 posts - 76 through 90 (of 1,626 total)