At that point, I realized that I should have a blog post that explains to easy way to recompile stored procedures. Today, we will learn about 2 methods.
Question: How to Use GOTO command in SQL Server?
Answer: Let us see a simple example of how GOTO works in SQL Server in this blog post.
While it was easy to write a stored procedure in SQL Server, for MariaDB and MySQL one has to know a bit of syntax to write the very first stored procedure.
This was a very interesting situation and at the end of we had found the culprit for the slow query and resolved it. Today we will discuss the experience.
Recently, one of my clients showed me a very cool trick to check Primary Key for a single table with the help of the system stored procedure sp_pkeys.
We started working with my Comprehensive Database Performance Health Check service and found very interesting details from the server cache.