SQL Server Indexes are similar to book indexes that we use to search any content in that book. They are very useful in faster data retrieval or data access. We create index on columns of tables or views. An index is...
Instant file initialization is very useful feature to speedup the process of increasing or allocating data file space of a SQL Server database. Have you ever thought how SQL Server initialized its database files during space allocation? General way to...
Today, i am going to discuss about virtual log files in SQL Server and query to find number of virtual log files present in transaction log files. Related Articles: Why Should You Always Turn Off Database Auto Shrink Property? Understand...
Have you deep dive into SQL Server checkpoint process like what checkpoints are and how they work? Here is an article which will explain you about checkpoint process in SQL Server. What is Checkpoint Process in SQL Server? As per...
Today, i will talk about SQL Server Transaction Log File Architecture. As we know, every database must have at least one transaction log file (Tlog file) that captures everything happens on database to maintain data integrity of the database. Logically,...
SQL Server data files, pages & extents are very much related to each other. These are architectural terms which are used to store data physically inside the database. First let’s start with data files then we will understand how data...
