Sept 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

  • 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
Count Sum

One Scan for 3 Count Sum – SQL in Sixty Seconds #178

July 2, 2021
Pinal Dave
SQL Tips and Tricks
Execution Plan, SQL Function, SQL in Sixty Seconds, SQL Index, SQL Scripts, SQL Server

Well, the answer is pretty straight forward and that is what we are going to see in today’s video of One Scan for 3 Count Sum.

Read More

SQL Server – Single Scan for 3 Operations – COUNT(*) COUNT(1) SUM(1)

June 30, 2021
Pinal Dave
SQL Performance
Execution Plan, SQL Function, SQL Index, SQL Scripts, SQL Server, SQL Server Management Studio, SSMS

Today we will take the same conversation to the next level by discussing Single Scan for 3 Operations – COUNT(*) COUNT(1) SUM(1).

Read More
sum

SUM(1) vs COUNT(1) Performance Battle – SQL in Sixty Seconds #177

June 29, 2021
Pinal Dave
SQL Video
Execution Plan, SQL Function, SQL in Sixty Seconds, SQL Scripts, SQL Server

Based on my recent two videos, I got lots of questions about SUM(1) vs COUNT(1) Performance Battle. Let us see that in today’s video.

Read More
Performance Observation

SQL SERVER – SUM(1) vs COUNT(*) – Performance Observation

June 25, 2021
Pinal Dave
SQL Performance
Execution Plan, SQL Scripts, SQL Server

One question that kept on coming up was SUM(1) vs COUNT(*) – Performance Observation. Well, let us see that today.

Read More
Collection of Articles

SQL SERVER – COUNT(*) Collection of Articles

June 24, 2021
Pinal Dave
SQL Performance
Execution Plan, SQL Server

Today we are building a Collection of Articles that have recently generated interest on the blog as well as on the YouTube channel –  SQL in Sixty Seconds. 

Read More
Battle

COUNT(*) and COUNT(1): Performance Battle – SQL in Sixty Seconds #176

June 23, 2021
Pinal Dave
SQL Video
Execution Plan, SQL in Sixty Seconds, SQL Scripts, SQL Server

COUNT(*) and COUNT(1): Performance Battle – which one is better for performance? I got this question after watching my previous video.

Read More
StarIndex

COUNT(*) and Index – SQL in Sixty Seconds #175

June 21, 2021
Pinal Dave
SQL Video
Execution Plan, SQL in Sixty Seconds, SQL Index, SQL Scripts, SQL Server

Earlier I wrote two blog post on the topic of COUNT(*) and Index and today I have to build a video on that topic as many of you really wanted.

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

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

Go to mobile version