June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

Interview Question of the Week #053 – What is the Difference Between Deterministic Functions and Nondeterministic Functions?

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks
SQL Function
Some questions are so theoretical that I believe they really do not add too much value if users know that question or not. Here is one such question I am very confident that you agree with my point of view. Questions: What is the Difference Between Deterministic Functions and Nondeterministic Functions?…
Read More

Interview Question of the Week #051 – Actual Execution Plan vs. Estimated Execution Plan

Pinal Dave
SQL Interview Questions and Answers
Execution Plan, SQL Server, SQL Server Management Studio

In one of the recent interview, I met quite a few interesting candidates. It is common for employees ask many questions during an interview, but there are times when candidates also ask questions back to the interviewee. I was asked following question recently.

Question: Do you use Actual Execution plan or Estimated Execution plan?

Read More

Interview Question of the Week #048 – How to Move TempDB to Another Drive?

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL TempDB
In a recent interview when the interviewer asked interview that TempDB can be moved to a different drive,  the candidate was extremely surprised. For the benefits of the interviewee who did not know the answer, I have written this blog post. Question: How to move TempDB to another drive? Answer:…
Read More

Interview Question of the Week #047 – Logic To Find Weekdays Between Two Dates

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks
I often enjoy seeing interview questions where the contestant has to write SQL Scripts. Here is another such example. Question: How to find weekdays between two dates? Answer: Here is a function which can be used to find weekdays between two dates. CREATE FUNCTION dbo.getDayCount(@startdate date, @enddate date) RETURNS INT…
Read More