Getting Approximate Count in Microsoft SQL Server
Sometimes performance is more important than exact accuracy. Learn how to get an approximate count in SQL Server with better performance.
2019-02-26
5,395 reads
count()
2018-02-09
1,055 reads
2018-02-02
1,112 reads
2018-01-26
1,106 reads
2018-01-19
1,172 reads
2015-02-02
2,361 reads
2015-01-23
2,618 reads
2015-01-22
2,425 reads
2015-01-21
2,571 reads
2015-01-14
2,550 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Is Fabric a Reliable Service or a Ripped Resource?
Comments posted to this topic are about the item Is Fabric a Reliable Service...
locking down agent for new user on our dev machine
hi , a new user wants to be able to add sql agent jobs...
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers