I do a performance tuning consulting to earn my livelihood. Once in a while, I end up customer who wants to interview me to check if I know SQL. I absolutely have no problem with the interview. This is a good thing and it gives me confidence that they are serious with their project. With said that once in a while the senior guys on the other side are so busy they end up having my interview with junior (novice) experts. I often struggle with this interview question and answer with beginners because my answers are based on experience and they often do not match what they have learned in school/collage.
SELECT One by Two – Why Does SELECT 1/2 Returns 0 – Interview Question of the Week #067
Just like a week, during a user group meeting I was told to ask questions about why the SELECT 1 /2 gives a different answer then one user is expected. Let us see this question in detail about SELECT One by Two as it can be a great learning for many new beginners.
What is ACID Property in Database? – Interview Question of the Week #066
Today I want to take you all back to the one of the very original database interview questions and answer which I see often discussed in the interview. I have previously written about this ACID properties as well. In my career, I have seen 1000s of the interview. One of my most popular services is to help people with interview questions and answers. I have often observed when interviewer runs out of questions to ask and thinking of the next question, they often ask this question about ACID Property of the database.
SQL SERVER – Who Changed the Password of SQL Login? – Interview Question of the Week #065
Today’s interview question was not really asked interview, but it is indeed a real world scenario which everyone should know the answer of. I strongly suggest you bookmark this blog post at once in your lifetime you will need this blog post to know who changed the password of your SQL Login?
Question: Who changed the password of SQL Login?
Answer: Continue to read the answer.
What is a Self Join? Explain with Example – Interview Question of the Week #064
A very popular question I often see in the interviews of developers. It does not matter if you are a SQL developer, .NET developer, JAVA developer or Python Developer, this question is always popular in any interviews. The question is about join in the SQL and it is about SELF JOIN.
Question: What is a Self Join?
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.
Interview Question of the Week #062 – How to Find Table Without Clustered Index (Heap)?
Question: How to Find Table Without Clustered Index (heap)?
Answer: In SQL Server, when we create a primary key it automatically creates clustered index on the table, unless we explicitly mentioned not to create one. Due to this reason, the most of the table where there is a primary key, there are good chances it is also a clustered index key.