checkpoints

Understanding SQL Server Recovery Model

A Recovery Model is a database property that designed to control transaction log maintenance. SQL Server Recovery Model does not…

How to Get Total Number of Virtual Log Files inside SQL Server Database Log Files?

Today, i am going to discuss about virtual log files in SQL Server and query to find number of virtual…

What is Checkpoint Process in SQL Server?

Have you deep dive into SQL Server checkpoint process like what checkpoints are and how they work? Here is an…