SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Guest Columnist: Igor Micev

SQLServerCentral.com profile

   Items 1 to 3 of 3   

CPU Spikes Caused by Periodic Scheduled Jobs

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.  Read more...
By Igor Micev 2016/12/20 | Source: SQLServerCentral.com | Category: agent jobs
Rating: |  Discuss |   Briefcase | 1,255 reads

Target Recovery Interval and Indirect Checkpoint

Indirect checkpoint is the recommended configuration, especially on systems with large memory footprints and default for databases created in SQL Server 2016.  Read more...
By Igor Micev 2016/07/21 | Source: SQLServerCentral.com | Category: configuration
Rating: |  Discuss |   Briefcase | 833 reads

The COUNT Function in T-SQL

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.  Read more...
By Igor Micev 2018/02/09 (first published: 2016/07/12) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,208 reads
   Items 1 to 3 of 3