In order to ensure consistency, you need to run the DBCC CHECKDB SQL Server command regularly. I'll talk more about CHECKDB later in this article. First, let's talk about database corruption.

• DBCC, SQL Server’s internal consistency checking utility, scales up by seven times. And that improvement happens despite having much additional consistency and logical checks.