Performance Effect of Number of Virtual Log Files in SQL Server

Overview

The transaction log files, records all the changes made to the SQL Server database as well as keeps the transactions. It is known to be the inevitable part of the SQL Server. These files are again divided into smaller virtual log files. If the number of virtual log files is more then, it is clear that the performance of transaction logs will get slow down. Here, in this session you will get to know about it in detail. Anyways, before moving into the effects, let’s have a check on what is ‘Virtual Log’ file. Continue reading “Performance Effect of Number of Virtual Log Files in SQL Server”

Methods for Tracking Login Password Changes in SQL Server

Tracing is a onetime procedure run through an act to find out the root whereas tracking is a continual process. To remain updated with the regularly made changes, tracking of an activity must be done. Similarly, on an SQL Server, one can track down the login password changes in SQL Server. However, SQL Server is not programmed to maintain a log of the changes in password taking place, by default. Continue reading “Methods for Tracking Login Password Changes in SQL Server”

Importance of SQL Server Backup History for a Database

Why SQL Server Backup History Important For A Database

What is the use with backup files? How will they make a way of help? Now, all the enterprise stores their information in the SQL Server database and it makes a way for backing up the data. Backup files are of great importance for any organization since when some problem strikes the backup files will help Continue reading “Importance of SQL Server Backup History for a Database”

Difference Between Deadlock And Blocking In SQL Server

Introduction

Deadlock and Blocking in SQL Server are two familiar terms seen in SQL Server. But, many are getting confused with these terms in the SQL Server. The users get messed up with these though they are not the same. Both these characteristics are different and you will get to know about the difference between deadlocks and blocking in SQL Server from the coming sessions. Before moving on to the difference, let’s get to know about these separately. Continue reading “Difference Between Deadlock And Blocking In SQL Server”

Insert into table with default values only

In this article you will find how to insert a row without any specified values in SQL Server table, if the columns have default values.

I recently had this issue. I had a table with only two columns one of which was auto-increment and the other had a GETDATE() default value. I needed to insert a record programmatically with default value. I didn’t knew how to insert a record without specifying any values. First I tried to insert it with GETDATE(), but since that column had it by default I wanted more elegant solution.

After some searching I found the best way to do it is this:

 INSERT INTO Your_Table DEFAULT VALUES

I hope it helps!

Blog at WordPress.com.

Up ↑