User Profile
SqlAvfc
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Performance Issue, Different times of the day
Hi, We have an azure synapse analytics dedicated sql pool, and something strange is happening with it. Basically I run a simple SQL Select Statement like the following between business hours (08:00 AM to 18:00 PM) and results return instantly. SELECT * FROM Prs.SalesOrderLine , When I try running the same query in the evening (22:00 PM) it just hangs and I have to force it to cancel and I get the below error message: Msg 111202, Level 16, State 1, Line 2 111202;Query QID3399532 has been cancelled. Query was canceled by user. Any ideas what could be happening? I am bit disappointed with Azure Synapse Analytics to be honest. ThanksWhen I am creating a Branch from with the Task the "based on" drop down list is showing me the repos
When I am creating a Branch from with the Task the "based on" drop down list is showing me the repositories instead of Branches. I used to be able to see the Branches for the respository, now all of a sudden this has changed? The only way I can do this now, is by doing the following: Repos > Branches > New Branch - This then pops up a window where I can give the Branch a name i.e task number/feature-update-table and then on theBased onI can then click on theDevelopmentbranch Would anyone know what changes may have happened?Stored Procedure Input Parameter Needed Power Automate
Hi, I currently have a Stored Procedure that does not have any Input Parameters, it basically updates a Calendar Table, setting columns like CurrentDay, PreviousDay, CurrentMonth etc... to 1 or 0 if the conditions matches. I wanted to use Power Automate to run this stored procedure at 12:00 everyday but it failed because Power Automate only executes Stored Procedures with an Input Parameter https://docs.microsoft.com/en-us/connectors/sql/#execute-stored-procedure-(v2) What is the most efficient way to add an Input Parameter to my current stored procedure but basically does nothing but still does the update is meant to do. Thanks
