How do I know Stored Procedure is slowly running or doesn't have any performance issue? After creating Stored Procedure, you must have a look at the Query Execution Plan . If you have Index/Table scan and also if it says that there are missing index then there is a performance issue and it is possible to fine-tune it. Optimization Tips To Increase SQL Server Stored Procedure Performance - 1. Use stored procedures instead of heavy-duty queries. 2. Include the SET NOCOUNT ON statement into your stored procedures to stop the message indicating the number of rows affected by a Transact-SQL statement. 3. Call stored procedure using its fully qualified name. 4. Consider returning the integer value as a RETURN statement instead of an integer value as part of a recordset. 5. Don't use the prefix "sp_" in the stored procedure name if you need to create a...
Angular, React, JavaScript, Java, PHP, SQL, C#, Vue, NodeJs, TypeScript and Interview Questions Answers