After so many years of existence of the stored procedures, I still see developers struggling to execute the stored procedure. Every other day I receive a question in an email asking how to pass parameters to the stored procedure.
How to Insert Results of Stored Procedure into a Temporary Table? – Interview Question of the Week #124
Question: How to Insert Results of Stored Procedure into a Temporary Table?
Fastest Way to Display Code of Any Stored Procedure – Interview Question of the Week #094
A very common question I often see users not sure about the answer. This is indeed a tricky question, but a very simple one. If I am the interviewer, I may ask this question to the user, but if they do not know the answer of this question, I would not give any negative remarks to interviewee. I think it is even old school to even ask these kind of questions. It has been long since I have stopped asking this question, once in a while, I still see this question being asked by my fellow colleagues. Well, let us revisit the age old question again about the fastest way to display code of any stored procedure.
How to Hide Stored Procedure’s Code? – WITH ENCRYPTION – Interview Question of the Week #088
Question: How to Hide Stored Procedure’s Code so anyone with access to stored procedure cannot see it?
SQL SERVER – System Stored Procedures I Use to Get Started
Call me an old school or whatever – there are certain things I believe in strongly. I have a working style and these in my opinion have evolved over years. I keep innovating myself as I learn on my way but there are few things I do that always makes me think I have not changed much. Let us learn about System Stored Procedures I Use to Get Started.
List All the Stored Procedure Modified in Last Few Days – Interview Question of the Week #070
In the interview and I end up seeing candidates failing to answer this question about the Stored Procedure Modified recently.
Interview Question of the Week #063 – How to Recompile Stored Procedure for Specific Table?
I have kept busy with SQL Consultancy now a days. Just the other day, while doing performance tuning exercise we had made major changes in the data stored in one of the main tables. The impact was so huge that we realized that it will impact how the SQL Server engine is building execution plans for that table. This brought up a question among us that – How to Recompile Stored Procedure for Specific Table? Well, this time the question was really not asked in the interview, but I really feel that it will be nice to address it here in this series.