T-SQL

SQLServerCentral Article

The COUNT Function in T-SQL

  • Article

The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it should be used carefully because it could often not return the desired result. For the big tables, the counting of the rows could cause blocking as well as take some more time.

(47)

You rated this post out of 5. Change rating

2018-02-09 (first published: )

10,957 reads

Blogs

Enterprise AI Operating Rhythm – Top 5 practices for 2026

By

2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened...

Stop Being Surprised by Your Azure Bill: Use Budgets

By

When organizations migrate workloads to Azure, the focus is usually on architecture, performance, and...

Resetting on the AI hype train

By

There's a great article from MIT Technology Review about resetting on the hype of...

Read the latest Blogs

Forums

Celebrating Tomorrow

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Celebrating Tomorrow

SQL Art: I Made a Christmas Card In SSMS

By tedo

Comments posted to this topic are about the item SQL Art: I Made a...

lookup error

By support@omniverter.com

I am using ssrs in visual studio 2022, I work on a report, there...

Visit the forum

Question of the Day

Celebrating Tomorrow

Which of these is more appropriate for tomorrow?

See possible answers