sql interview questions and answers

What is N in nvarchar? – Interview Question of the Week #301

Question: What is N in nvarchar? Answer: n in nvarchar or nchar stands for...

Một số câu hỏi phỏng vấn liên quan đến SQL mà bạn nên biết^^

Những bài viết trước mình đã chia sẻ những kiến...

How to Write Efficient Query? – Interview Question of the Week #300

Question: How to Write Efficient Query?Answer: There is no right or wrong...

How to Add Constraint With No Validation? – Interview Question of the Week #299

Question: How to Add Constraint With No Validation?Answer: I got this question...

What is EDGE in SQL Server Execution Plan? – Interview Question of the Week #298

Question: What is EDGE in SQL Server Execution Plan?Answer: It is the arrow or...

How to Capture Deleted Rows Without Trigger? – Interview Question of the Week #297

Question: How to Capture Deleted Rows Without Trigger?Answer: I was recently...

How to Change Database File Size? – Interview Question of the Week #296

Question: How to Change Database File Size?Answer: By Shrinking the files. Now, many have a negative opinion about the Shrinkfile but the question is how to change the file size and the answer of the same is by...

How to Get Volume Mount Point for SQL Server Files? – Interview Question of the Week #295

Question: How to Get Volume Mount Point for SQL Server Files?Answer: I was asked this question by my client during the recent Comprehensive Database Performance Health Check. You run the following script to get all...

SQL SERVER – Simple Explanation FORCE DEFAULT CARDINALITY ESTIMATION

I enjoy learning new things every single day and I must express my gratitude to all of you for helping me learn new things. One of my client Comprehensive Database Performance Health Check recently asked me if I can...

What is Temp Stored Procedures? – Interview Question of the Week #294

Question: What is Temp Stored Procedures?Answer: Temp stored procedures are kind of the stored procedures that are created with the help of the # at the beginning of the name and only available until the SQL Server...

Where are SQL Jobs Stored? – Interview Question of the Week #293

Question: Where is SQL Jobs Stored?Answer: In MSDB Database in dbo.sysjobs table.This question was actually asked to me on my YouTube Channel. The user wanted to know in case if SQL Job was deleted accidentally where...

When was Stored Procedure Last Compiled? – Interview Question of the Week #292

Question: When was Stored Procedure Last Compiled?Answer: Honestly, it is difficult to figure out when was the stored procedure last compiled. As a matter of fact, SQL Server does not keep this information out in the...

What Happens If the Clustered Index is Disabled? – Interview Question of the Week #291

Question: What Happens If the Clustered Index is Disabled?Answer: If you disable the clustered index, you can’t retrieve data from the table. Technically the entire table goes offline, till you rebuild your clustered...

How to Insert Multiple Values into Multiple Tables in a Single Statement? – Interview Question of the Week #290

Question: How to Insert Multiple Values into Multiple Tables in a Single Statement?Answer: One of the most popular questions, I often receive from my client Comprehensive Database Performance Health Check. I often see...

Do MAX Function Scan Table? – Interview Question of the Week #289

Question: Do MAX Function Scan Table to retrieve the data?Answer: Yes, if there are no indexes to help retrieve data.I personally hate answers which are ambiguous and I also do not like to say it depends as well. Let me...

How to Get Rowcount of Every Table in SSMS? – Interview Question of the Week #288

Question: How to Get Rowcount of Every Table in SSMS?Answer: After watching my earlier video on the fastest way to get the rowcount for the table, I got lots of questions from the user, if there is a way to list...

How to Install SQL Server 2019? – Interview Question of the Week #287 – SQL in Sixty Seconds #092

Question: How to Install SQL Server 2019?Answer: This is one of the unique blog posts in the history of SQLAuthority where I am merging two of the blog post category together 1) SQL in the Sixty Seconds 2) SQL Interview...

What is Full Outer Join With Exclusion? – Interview Question of the Week #286

Question: What is Full Outer Join With Exclusion?Answer: I got this question after reading my earlier blog post about SQL SERVER – Introduction to JOINs – Basic of JOINs. The question was from my regular client of...

How to Generate Script for SQL Server 2005 from SQL Server 2019? – Interview Question of the Week #285

Question: How to Generate Script for SQL Server 2005 from SQL Server 2019?Answer: Actually, I got this question from my client of Comprehensive Database Performance Health Check. The answer is very simple, yes you can...

How to Combine Time and Date in SQL SERVER? – Interview Question of the Week #285

Question: How to Combine Time and Date in SQL SERVER?Answer: A very simple and popular question. Let us see how we can combine and date and time in SQL Server.Method 1: Using + Combine Time DateLet us run the following...

What are Different Layers of Open Source Cloud? – Interview Question of the Week #284

Question: What are Different Layers of Open Source Cloud?Answer: This question is actually the seventh post in the series which captures my notes with various CXOs during the Comprehensive Database Performance Health...

What does Verify Backup When Finished do in SQL Server? – Interview Question of the Week #283

Question: What does Verify Backup When Finished do in SQL Server?Answer: It will check up if the backup media is in the place and also checked the header information to make sure that it looks like the header of the...

Does BIT Datatype Equal to 1 or TRUE in SQL Server? – Interview Question of the Week #282

Question: Does BIT Datatype Equal to 1 or TRUE in SQL Server?Answer: Very interesting question. Let us answer this question with the help of a demonstration.Here is the sample script:DECLARE @myBIT BIT SET @myBIT =...

How to Force Index on a SQL Server Query? – Interview Question of the Week #281

Question: How to Force Index on a SQL Server Query?Answer: I personally do not like to force an index on any query. As a matter of fact, I have enough bad experience with this one. I always recommend in my Comprehensive...

Can a Database Have Multiple Files with Extension MDF? – Interview Question of the Week #279

Question: Can a Database Have Multiple Files with Extension MDF?Answer: Yes. It is possible to have multiple files with extension MDF for a single database.If your answer was yes. You can stop reading this interview...