March 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
  • Training
SQL Server Interview Questions and Answers: Updated 2021

SQL Server Interview Questions and Answers: Updated 2021

March 4, 2021
Pinal Dave
SQL Interview Questions and Answers
SQL Book, SQL Server

I have just released an updated version of my most famous SQL Server Interview Questions and Answers: Updated 2021 after 10 years.

Read More
nvarchar

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

January 21, 2021
Pinal Dave
SQL Interview Questions and Answers
Data Type, SQL Server, SQL String

Question: What is N in nvarchar?

Answer: n in nvarchar or nchar stands for world national. Let us learn today about datatypes.

Read More
Efficient Query

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

November 1, 2020
Pinal Dave
SQL Interview Questions and Answers
Query Rewrite, SQL Milestone, SQL Server

Question: How to Write Efficient Query?

Answer: There is no right or wrong answer to this question. Let us learn about it today.

Read More
no validation

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

October 25, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL Constraint and Keys, SQL Error Messages, SQL Identity, SQL Scripts, SQL Server

Question: How to Add Constraint With No Validation?

Answer: I got this question from one of my clients of who is an Oracle user.

Read More
what is edge

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

October 18, 2020
Pinal Dave
SQL Interview Questions and Answers
Execution Plan, SQL Performance, SQL Server Management Studio, SSMS

Question: What is EDGE in SQL Server Execution Plan?

Answer: It is the arrow or the line which goes from one operator to another operator.

Read More
Deleted Rows

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

October 11, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL Delete, SQL Performance, SQL Scripts, SQL Server, SQL Trigger

Question: How to Capture Deleted Rows Without Trigger?
Answer: I was recently asked by my client during the Comprehensive Database Performance Health Check.

Read More
Change Database

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

October 4, 2020
Pinal Dave
SQL Interview Questions and Answers
Shrinking Database, SQL Performance, SQL Scripts, SQL Server, SQL Server DBCC

Question: How to Change Database File Size?

Answer: By Shrinking the files. Now, many have a negative opinion about Shrinkfile.

Read More
1 2 3 4 … 67 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2023 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version