May 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • 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
SQL Server Deadlocks

SQL Server Deadlocks – Interview Q and A

June 23, 2023
Pinal Dave
SQL Interview Questions and Answers
Deadlock, SQL Performance

Earlier this week, I wrote a few blog posts on SQL Server Deadlocks. Lots of people asked me if I could convert them into Interview Questions and Answers

Read More
CumulativeTotalCalculation

SQL SERVER Challenge – Cumulative Total Calculation

June 16, 2023
Pinal Dave
SQL Interview Questions and Answers
Challenge, CTE, Ranking Functions, SQL Scripts, SQL Sub Query

Today we will see a very interesting SQL SERVER Challenge about Cumulative Total Calculation. During a recent Comprehensive Database Performance Health Check.

Read More

SQL SERVER – Count Occurrences of a Specific Value in a Column

June 12, 2023
Pinal Dave
SQL Interview Questions and Answers
SQL Group By, SQL Server

Here is the exact question – How to Count Occurrences of a Specific Value in a Column? Well, honestly, the answer is very simple.

Read More
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
1 2 3 4 … 67 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version