Question : I have a database with ‘books’ (short stories for children) and it would be extremely informative to have […]
Tag: stored-procedures
stored procedures location influence their performance?
Question : I have a procedure SP_MYPRO that updates data in MYDB1. 1) the performance of SP_MYPRO would be different […]
Facing permission error while trying to execute a stored procedure published through CLR
Question : I’ve created a stored procedure using SQL CLR c# stored procedure in Visual Studio 2017 and I’ve published […]
SQL Server, ServicerBroker for asynchronized execution of stored procedures
Question : I followed this tutorial: https://gallery.technet.microsoft.com/scriptcenter/Using-Service-Broker-for-360c961a and it is working for me, However, I don’t understand some thing: At […]
Inner procedure is rolled back but outer procedure is still committed
Question : I have an outer procedure which calls 5 different inner procedures something like Parent procedure(Tran/try/catch) Inner sp1 (Tran/try/catch) […]
Is ASYNC_NETWORK_IO wait type anything to worry about?
Question : In looking at the list of stored procedures that take long time to execute, one stands out as […]
How to make stored procedure with outputs OUT sys_refcursor, OUT varchar2, and OUT number, then use in c#.net app
Question : What is the syntax for a stored procedure that outputs a refcursor, a varchar2, and a number? I […]
SQL Server Management Send Mail as Part of a Job
Question : I have a SQL Job that I would like to send an email through, but for some reason […]
metadata could not be determined because stored procedure contains dynamic SQL
Question : I have a stored procedure that contains some dynamic SQL. I am trying to execute the stored procedure […]
Can sp_BlitzFirst pass the @ExpertMode parameter to sp_BlitzWho [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]