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.
2018-02-09 (first published: 2016-07-12)
10,912 reads
This article shows how to reduce the periodic spikes in the CPU that are caused by the periodic-executing jobs. There is a good reason to make some changes for dismissing them.
2016-12-20
1,601 reads
Indirect checkpoint is the recommended configuration, especially on systems with large memory footprints and default for databases created in SQL Server 2016.
2016-07-21
10,289 reads
By Steve Jones
immerensis – n. the maddening inability to understand the reasons why someone loves you...
In this post, I will guide you on how to deploy a dockerized simple...
By Kevin3NF
Everything in SQL Server is waiting for something…this is by design. And most people...
Creating an Windows Server Fail-over Clusters with two SQL server 2022 and a File...
hi a few days ago i narrowed down the cause of a new problem...
I have a database that is in full backup recovery model. When the log...
At what levels can we set the collation in SQL Server 2022?
See possible answers