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

SQL SERVER – Count Occurrences of a Specific Value in a Column

June 12, 2023
Pinal Dave
SQL Interview Questions and Answers
SQL Group By, SQL Server

Here is the exact question – How to Count Occurrences of a Specific Value in a Column? Well, honestly, the answer is very simple.

Read More
Stream Aggregate

SQL SERVER – Stream Aggregate and Hash Aggregate

February 17, 2020
Pinal Dave
SQL Performance
Execution Plan, MAXDOP, Parallel, Query Hint, SQL Group By, SQL Operator, SQL Server Management Studio, SSMS

Recently during the on-demand consultation, I was asked a very interesting question about Stream Aggregate and Hash Aggregate.

Read More
Orders Data

SQL SERVER – Group By Orders Data by Columns Ascending

October 23, 2019
Pinal Dave
SQL Tips and Tricks
SQL Group By, SQL Order By, SQL Scripts, SQL Server

The question was about Group By Orders Data by Columns Ascending. DBA asked me an interesting question referring to my older blog.

Read More
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version