After troubleshooting they found that when they run vssadmin list writers command from the command prompt, they are not seeing SqlServerWriter.
Question: How to Recompile Stored Procedure?
Answer: The answer to this question is here:
EXEC sp_recompile ‘NameofSP’
Let us read more about it.
I had a very interesting conversation with one of my clients about Carnality Estimation for Temp Table vs Table Variable. Let us discuss it today.
There is a limitation of how many classes, I can deliver in person. That is why I have converted my most popular training to Online Recorded Class.