Question: What is a Backup Timeline for Restore Process?
Answer: One of the most popular interview question about Backup and Restore Database process.
How to Introduce Time Delay Between Two T-SQL Commands? – Interview Question of the Week #091
Question: How to Introduce Time Delay Between Two TSQL Commands?
SQL SERVER – How to Find Out When Your SQL Login Will Expire?
If you are a SQLDBA, you must have created a login and you must have known about enforcing password policy to SQL Logins. Once of my client asked to provide script to find expiry details about SQL Login. It was an easy task. I went to books online and used LOGINPROPERTY function and passed name to all the possible parameters. Below would work for SQL 2008 onwards.
Identify Used Space in Log File- Interview Question of the Week #090
Question: How to identify Used Space in Log File?
Answer: Use following command to display used log file size and total used space in the log file.
How to Find Missing SQL Server Configuration Manager? – Interview Question of the Week #089
Question: I just installed the latest version of SQL Server and now I am not able to find SQL Server Configuration Manager. What should I do?
How to Hide Stored Procedure’s Code? – WITH ENCRYPTION – Interview Question of the Week #088
Question: How to Hide Stored Procedure’s Code so anyone with access to stored procedure cannot see it?
How to Find Recent Executed Queries in SQL Server? – Interview Question of the Week #087
Interviews are fun. Most of the time the interviewer has all the interesting questions, but I often come across a few individuals who stomps the interviewer. I was recently called by one of the organizations where I regularly help with their hiring process. They were stumped by interviewing candidates with one of the questions related to recent executed queries. Let us see the question and its answer.