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.
How to Use GOTO command in SQL Server? – Interview Question of the Week #249
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.
SQL SERVER – Stored Procedure and RETURN Keyword
The stored procedure was very long and we had to debug that one step at a time. Let us learn about Stored Procedure and RETURN Keyword.
MySQL – MariaDB – Writing the Very First Stored Procedure
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.Â
SQL SERVER – 5 Important Steps When Query Runs Slow Occasionally
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.
SQL SERVER – Show Primary Key for a Single Table – sp_pkeys
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.
SQL SERVER – List All Frequently Ran Stored Procedure From Server Cache
We started working with my Comprehensive Database Performance Health Check service and found very interesting details from the server cache.Â