What is the ACID Property in a database? A classic interview question, with Atomicity, Consistency, Isolation and Durability explained in plain words.
SQL SERVER – Who Changed the Password of SQL Login? – Interview Question of the Week #065
Who changed the password of your SQL Login? It is a real world question every DBA faces one day. Bookmark this post, here is how to find the answer.
What is a Self Join? Explain with Example – Interview Question of the Week #064
What is a Self Join? It is a popular interview question for every developer. Here is a simple answer, whether it is inner or outer, and a practical use.
Interview Question of the Week #063 – How to Recompile Stored Procedure for Specific Table?
After a big data change in one table, we wanted fresh plans. Here is how to recompile stored procedure plans for a specific table, with a word of caution.
Interview Question of the Week #062 – How to Find Table Without Clustered Index (Heap)?
Not every table has a clustered index. Here is a quick script to find each table without a clustered index, also called a Heap, in your database.
Interview Question of the Week #061 – How to Retrieve SQL Server Configuration?
A common interview question: how do you retrieve SQL Server configuration? Right-click and Properties is not enough. Here is the better answer.
Interview Question of the Week #060 – What is the Difference Between EXCEPT Keyword and NOT IN?
Even 11 years after SQL Server 2005, few people I interview know the EXCEPT keyword. Here is how EXCEPT differs from NOT IN, with simple examples.