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
Last Compiled

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

September 6, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL Cache, SQL Performance, SQL Scripts, SQL Server, SQL Stored Procedure

Question: When was Stored Procedure Last Compiled?

Answer: Honestly, it is difficult to figure out when was the stored procedure last compiled.

Read More
Index is Disabled

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

August 30, 2020
Pinal Dave
SQL Interview Questions and Answers
Clustered Index, SQL Error Messages, SQL Index, SQL Scripts, SQL Server

Question: What Happens If the Clustered Index is Disabled?

Answer: If you disable the clustered index, you can’t retrieve data from the table.

Read More
Insert Multiple

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

August 23, 2020
Pinal Dave
SQL Interview Questions and Answers
Execution Plan, SQL Scripts, SQL Server

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

Read More
Function Scan

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

August 16, 2020
Pinal Dave
SQL Interview Questions and Answers
Execution Plan, SQL Performance, SQL Scripts, SQL Server

Question: Do MAX Function Scan Table to retrieve the data?

Answer: Yes, if there are no indexes to help retrieve data. Let us learn it today.

Read More
get rowcount

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

August 9, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL Server, SQL Server Management Studio, SQL Table Operation, SSMS

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,

Read More
SQL SERVER 2019 Install

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

August 2, 2020
Pinal Dave
SQL Interview Questions and Answers, SQL Video
SQL in Sixty Seconds, SQL Server, SQL Server Configuration, SQL Server Installation

Question: How to Install SQL Server 2019?

Answer: This is one of the unique blog posts in the history of SQLAuthority, it is merged blog post.

Read More
Join With Exclusion

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

July 26, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL Joins, SQL Scripts, SQL Server

Question: What is Full Outer Join With Exclusion? 

Answer: I got this question after reading my earlier blog post about Basic of JOINs.

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

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

Go to mobile version