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
distinct

SQL SERVER – Distinct and ORDER BY

November 5, 2020
Pinal Dave
SQL Tips and Tricks
Execution Plan, SQL Operator, SQL Order By, SQL Scripts, SQL Server

I have made note that ORDER BY is not required when DISTINCT is used. Let us understand the same subject in detail. Let us learn today.

Read More
zero

SQL SERVER – Scan Count Zero for Statistics IO

October 28, 2020
Pinal Dave
SQL Performance
Execution Plan, Primary Key, SQL Scripts, SQL Server, SQL Statistics

On the production server and they noticed scan count as Zero on the result. They reached out to me asking what actually it means.

Read More
arrow

Arrow in Execution Plan – SQL in Sixty Seconds #136

October 20, 2020
Pinal Dave
SQL Video
Execution Plan, SQL in Sixty Seconds, SQL Operator, SQL Server, SQL Server Management Studio, SSMS

Do you know what a single arrow means in an execution plan? While we popularly call it the arrow, there is a technical name for these little arrows.

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
statistics IO

SET STATISTICS IO ON – SQL in Sixty Seconds #128

October 5, 2020
Pinal Dave
SQL Video
Execution Plan, SQL in Sixty Seconds, SQL Scripts, SQL Server, SQL Server Management Studio, SQL Statistics, SSMS

I am working with clients on helping them tune their SQL Server Performance. Let us learn how we can use SET STATISTICS IO to check the query’s performance.

Read More
full-screen

Full-Screen Execution Plan – SQL in Sixty Seconds #117

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

There are two primary tools – 1) Execution Plan and 2) Statistics IO. In this blog post, we will see how we can get the full-screen execution plan. 

Read More
running query

Activity Monitor and Running Query – SQL in Sixty Seconds #115

September 2, 2020
Pinal Dave
SQL Tips and Tricks
Execution Plan, SQL Activity Monitor, SQL in Sixty Seconds, SQL Scripts, SQL Server

Activity Monitor can come handy when you are in trouble as well. We will see how we can take the help of Activity Monitor to track Actively Running Query.

Read More
Previous 1 … 4 5 6 7 8 9 10 … 18 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version