Difference Between Count and Count_Big Functions in SQL Server

Hello everyone,

In this article, I will give information about the difference between Count and Count_Big functions in SQL Server.

There is no difference in functionality between Count and Count_Big. They are almost the same. The only difference is the data type they return and the indexing on the view.

When you use the COUNT(*) function, it returns the data type as INT (range: -2^31 (-2.147.483.648) to 2^31-1 (2.147.483.647) and storage 4 bytes), while using COUNT_BIG(*) it returns data as BIGINT type (range: -2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807) and storage 8 bytes).

Good luck to everyone in business and life.