Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

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