Forum Replies Created

Viewing 15 posts - 16 through 30 (of 1,577 total)

  • Reply To: slow update query

    table and script trigger attached.

    Thanks

  • Reply To: slow update query

    Also the trigger is to add logs to another table. This is usually used when user change address from user interface web site, so it is usually one record one...

    • This reply was modified 7 months, 3 weeks ago by  sqlfriend.
  • Reply To: slow update query

    Yes,  I did check the log space, I see there is plenty space while it is running.

    This is a non-production environment for me to scramble data.

    So I was able to...

  • Reply To: extract columns from a string column

    That works perfectly, thanks much!

  • Reply To: store data

    Thank you. It looks like the Modern_Spanish_CI_AS stored spanish mainly. What we want is still a database mostly stored English, but just for sometimes if users like to display their...

  • Reply To: non-prod database data scrambling

    A second thought I do have license of Redgate of data generator as in the toolbelt bundle. Never used this tool, but maybe it can be used to replace columns'...

  • Reply To: non-prod database data scrambling

    Thanks all.

    For answering this question:  But do you really need the whole production database in  none prod?  Could you get away with using a blank schema and using a data...

  • Reply To: non-prod database data scrambling

    Thank you both.

    The product is good, but it is expensive. Not sure if we can get approval to have budget for that.

    Any other recommendations?

    Thanks

    • This reply was modified 8 months, 1 week ago by  sqlfriend.
  • Reply To: ownership chain

    Yes, I totally understand the user cannot run the select query, because he doesnot have permissions on Production schema.

    It is the stored procedure permissions that confused me. But Andy's answer:...

  • Reply To: Performance tuning

    Thanks for your recommendations. What I can say is the .exe is calling our local web application that calls vendor's web service end points. Vendor side web service is the...

    • This reply was modified 1 year, 1 month ago by  sqlfriend.
    • This reply was modified 1 year, 1 month ago by  sqlfriend.
  • Reply To: Performance tuning

    Yes, the step is execute process task that has a executable C:\_SSISFILES\Miscellaneous\eLinkUtility\Transportation.ETL.VersaTransToStaging.exe

     

    The executable call the web service that has endpoints.

  • Reply To: Performance tuning

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

  • Reply To: Performance tuning

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

  • Reply To: Performance tuning

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

    • This reply was modified 1 year, 1 month ago by  sqlfriend.
  • Reply To: Performance tuning

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

    • This reply was modified 1 year, 1 month ago by  sqlfriend.

Viewing 15 posts - 16 through 30 (of 1,577 total)