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.
Interview Question of the Week #061 – How to Retrieve SQL Server Configuration?
I have observed this question in the interview question few days ago. I had a fun time to see candidates failing to answer this question. The most common answer candidate gave us was that they will right click on the server and see the properties. Well, that option will not give all the details which actual question intended. Let us see the question:
Question: What is the best way to see all the options set for your SQL Server programmatically?
Answer: