June 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
Email and Execution

Email an Execution Plan – SQL in Sixty Seconds #114

September 1, 2020
Pinal Dave
SQL Video
Execution Plan, SQL in Sixty Seconds, SQL Server, SQL Server Management Studio, SSMS

Today we are going to learn how we can send Email an Execution Plan. In the video, I explain how one can send query plans via an email.

Read More
Estimated vs Actual

Execution Plan – Estimated vs Actual – SQL in Sixty Seconds #113

August 31, 2020
Pinal Dave
SQL Video
Execution Plan, SQL in Sixty Seconds, SQL Performance, SQL Server Management Studio, SSMS

During the Comprehensive Database Performance Health Check, I often get the question about Estimated vs Actual Execution Plan. Let’s discuss.

Read More
Single Column

Single Column Single Row and TABLE SCAN – SQL in Sixty Seconds #111

August 27, 2020
Pinal Dave
SQL Video
Execution Plan, SQL in Sixty Seconds, SQL Operator, SQL Performance, SQL Scripts, SQL Server

Can a single column and single row result do an entire table scan? I recently got this question in my  Comprehensive Database Performance Health Check.

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
Scan Table

Do MAX(col) Scan Table? – SQL in Sixty Seconds #106

August 21, 2020
Pinal Dave
SQL Video
Execution Plan, SQL in Sixty Seconds, SQL Operator, SQL Performance, SQL Scripts, SQL Server, SQL Table Operation

While working on working on a Comprehensive Database Performance Health Check my client asked me – Do MAX(col) Scan Table? Let us learn about that today.

Read More
Live Query Statistics

SQL SERVER – Live Query Statistics – SQL in Sixty Seconds #104

August 19, 2020
Pinal Dave
SQL Video
Execution Plan, SQL in Sixty Seconds, SQL Performance, SQL Server, SQL Server Management Studio, SSMS

The biggest challenge is to know about the queries current execution status. In this video, we are going to see the details about Live Query Statistics.

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
Previous 1 … 5 6 7 8 9 10 11 … 18 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version