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
TOP and DISTINCT

SQL SERVER – TOP and DISTINCT – Epic Confusion – SQL in Sixty Seconds #141

November 4, 2020
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Operator, SQL Performance, SQL Scripts, SQL Server

DBAs from the client’s organization ended up an argument about how T-SQL works. The discussion was about the epic confusion about TOP and DISTINCT.

Read More
Efficient Query

Performance Challenge – Write Efficient Query – SQL in Sixty Seconds #140

October 30, 2020
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Operator, SQL Performance, SQL Scripts, SQL Server, SQL Server Management Studio, SSMS

Recently while working with my client I ended up in a very interesting situation where my client wanted me to write an Efficient Query.

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
adding values

SQL SERVER – Adding Values Containing NULLs

October 19, 2020
Pinal Dave
SQL Tips and Tricks
SQL NULL, SQL Operator, SQL Scripts, SQL Server

Today we will see a very simple blog post about Adding Values Containing NULLs. During the consulting engagement of Health Check.

Read More

Performance Comparison – IN vs BETWEEN – SQL in Sixty Seconds #127

October 2, 2020
Pinal Dave
SQL Video
SQL Comparison, SQL in Sixty Seconds, SQL Operator, SQL Scripts, SQL Server

Yesterday I blogged about SQL SERVER – Performance Comparison – BETWEEN, IN, and Operators. Following that, I got many emails about the topic.

Read More
operators

SQL SERVER – Performance Comparison – BETWEEN, IN and Operators

October 1, 2020
Pinal Dave
SQL Performance
SQL Operator, SQL Scripts, SQL Server

In today’s blog post let us discuss Performance Comparison – BETWEEN, IN, and Operators. I recently discussed this during the Health Check. 

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

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

Go to mobile version