MSSQL

Difference Between Primary Key and Foreign Key You can be find what is Primary Key and Foreign Key and what are differences between Primary Key …

We will talk about SQL Server Statistics in this article. What is Statistics in SQL Server? When you execute a query on SQL Server, it …

This article contains information about SQL Server indexes and performance effetc of indexes. What is Index in SQL Server? Indexes allow us to access data …

To better understand this article, I would first recommend reading the “Index Concept and Performance Effect on SQL Server” and “Statistics Concept and Performance Effect …

What is Vlf(Virtual Log File)? Vlf (Virtual Log File) is a virtual file, as the name implies. The Transaction Log file with the ldf extension in …

Can I Delete SQL Server Transaction Log File? We can not delete primary transaction log file, but we can delete secondary log files in SQL …

Why we want to add second log file? It is a process that we usually perform when there is no free space in the disk …

I wanted to write this article because it has been mentioned in the topic “How To Shrink SQL Server Transaction Log” and there are some …

Before shrinking the SQL Server log file, I recommend you read articles “What is SQL Server Transaction Log” and  “What is Database Recovery Model” that …

SQL Server Transaction Log is the log file with .ldf extension. Every transaction that occurs in SQL Server and database modifications performed by these transactions …