Temp stored procedures are the SPthat are created with the help of the # at the beginning of the name and only available until the SQL Server restarts.
Question: Where is SQL Jobs Stored?
Answer: In MSDB Database in dbo.sysjobs table. Let us learn about it in today’s blog post.
I will describe in detail a bit later on during this blog post. Today we are going to learn that it is possible to have a nonclustered primary key.
Question: When was Stored Procedure Last Compiled?
Answer: Honestly, it is difficult to figure out when was the stored procedure last compiled.
Activity Monitor can come handy when you are in trouble as well. We will see how we can take the help of Activity Monitor to track Actively Running Query.