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,036 reads
2018-02-02
1,088 reads
2018-01-26
1,088 reads
2018-01-19
1,149 reads
2015-02-02
2,342 reads
2015-01-23
2,603 reads
2015-01-22
2,406 reads
2015-01-21
2,554 reads
2015-01-14
2,535 reads
Blogs
Basic JSON Queries–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Daily Coping 30 Nov 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Building a Raspberry Pi cluster to run Azure SQL Edge on Kubernetes
A project I’ve been meaning to work on for a while has been to...
Forums
Performance and usage of system stored procedure sp_columns_100
Hello experts, I'm researching different ways to monitor SQL Server CPU usage by query....
Operand type clash: text is incompatible with datetime2
Dear Group: I am not sure what is causing this, and having a terrible...
Can I clone a database across servers?
Hi all, I have a database that resides on server A and I need...
Ask SSC