Categories
Sql Server

How To Add MySql As Linked Server In SQL Server

How To Add MySql As Linked Server In SQL Server In this post we will learn How To Add MySql As Linked Server In SQL Server.I have already discussed about LINKED SERVER. A linked server (a virtual server) may be considered a more flexible way of achieving remote access, with the added benefits of remote table access […]

Categories
Sql Server

Import Text File Using XP_CMDSHELL In SQL Server

Import Text File Using XP_CMDSHELL In SQL Server In this post we will learn how to Import Text File Using XP_CMDSHELL In SQL Server.There are several options available to import data from external sources to SQL Server. Such as Import & Export Wizard, BULK INSERT command, SSIS and OPENROWSET. Apart from this options you can also […]

Categories
Sql Server

SQL Server – When Will My Backup Finish?

SQL Server – When Will My Backup Finish? In this post we will learn When Will My Backup Finish? in SQL Server.The sys.dm_exec_requests is a great way to find out how long the BACKUP will take to complete. If you are doing a backup WITH STATS or by GUI, you will not need to use the DMV. But, […]

Categories
Sql Server

What Are Transactions In SQL Server

What Are Transactions In SQL Server Transactions are frequently defined as a set of actions that succeed or fail as a whole. To be more specific, transactions can provide four major functions to the data manipulation processes that access the database. 1. Atomicity: When two or more pieces of information are involved in a transaction, either all […]