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,981 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,685 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
11,075 reads
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
BCA KCP Pasar Kebayoran Lama Telpon/WA:08137887595.Jl. Raya Kby. Lama No.174, Cipulir, Kec. Kebayoran Lama,...
Jl. Danau Agung 2 No.1A Blok E2, Sunter Agung, Podomoro, Jkt Utara, Daerah Khusus...
BCA KCP Mega Kuningan Telpon/WA:08137887595.Lingkar Mega Kuningan No.Blok E 4, RT.5/RW.2, Kuningan, Kuningan Tim.,...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers