In this article, we look at backup checksums, how
they help and how to deal with media errors that arise when performing backups.
Apart from simply performing backup operations to safeguard your data, SQL Server also allows you to ensure that your backup data’s integrity is maintained. To make sure that the data you are backing up is free of errors, you can opt for creating a backup checksum. And depending on the kind of checksum used, you can identify problems with your backups if there...
Read more »
In
this article, we learn about backup checksums and how to disable them using
SSMS
The Checksum property in SQL Server can be put to use to detect what the changes are being made in SQL Server rows or expressions over a period of time. Tracking data and changes in an application like SQL Server can be very challenging and resource intensive at times. To help users deal with this challenge, they have been provided with the checksums property. Once you apply this to any given field or table,...
Read more »
This article explains all key points of CPU Affinity
Masks in SQL Server.
To make the
process of multi-tasking easier, Microsoft Windows often makes a shift in the
process threads belonging to different processors. This can help when looked from a point of
view of the operating system, but this can also lag the performance of the application
when there is a heavy load on the system. As the processor cache for each
process will be reloaded along with the data. The performance...
Read more »