This article demonstrates How to Fix Virtual Log Files in SQL Server Transaction Log file. The steps mentioned in this article are applicable on SQL Server 2005 and higher versions. To know more about how to Identify...
Tag - SQL Server Performance Tuning
How to Detect Virtual Log Files in SQL Server Transaction Log File
This article demonstrates how to Detect Virtual Log Files in SQL Server Transaction Log File. The steps mentioned in this article are applicable on SQL Server 2005 and higher versions. To know more about how to fix...
What are Virtual Log Files in SQL Server Transaction Log File?
Every transaction log file is logically divided into smaller segments and these segments are called Virtual Log Files or VLFs. VLF stands for Virtual Log File in SQL Server Transaction Log File How Virtual Log Files...
Why Model Database Default Settings Customization is Important for SQL Server?
What is a Model System Database? Model is a system database which is used as a template while creating newer user databases in SQL Server. Why you must make necessary changes to default settings of a Model System...
How to Move TempDB to New Drive in SQL Server
There are times when as a DBA you find the need to move TempDB Data and Log Files to a new Drive. This article explains all the steps you need to follow to move TempDB files.