Understanding SQL Server Indexes
SQL Server Indexes are similar to book indexes that we use to search any content in that book. They are…
7 years ago
SQL_Server_Architecture
What is Instant File Initialization and How to enable it on SQL Server Instance?
Instant file initialization is very useful feature to speedup the process of increasing or allocating data file space of a…
8 years ago
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…
8 years ago
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…
8 years ago
Understanding SQL Server Transaction Log File Architecture
Today, i will talk about SQL Server Transaction Log File Architecture. As we know, every database must have at least…
8 years ago
Understanding SQL Server Data Files, Pages & Extents
SQL Server data files, pages & extents are very much related to each other. These are architectural terms which are…
8 years ago