Author Archives: Mandeep Singh

How To Insert Multiple Rows Using A Single Query Using Union All

How To Insert Multiple Rows Using A Single Query Using Union All In this tutorial i will explain How To Insert Multiple Rows Using A Single Query Using Union All.We will insert multiple values through a single query using union all. Query: INSERT INTO Employee (Firstname ,Lastname ,Salary ,Department ) SELECT ‘Rajan’,’Singh’,5000,’ERP’ UNION ALL SELECT ‘Ram’,’Singh’,40000,’IT’

How To Enable Dedicated Administrator Connection in SQL Server

How To Enable Dedicated Administrator Connection in SQL Server In This Post i will let you know How To Enable Dedicated Administrator Connection in SQL Server.I have already explained How to Use Dedicated Administrator Connection in SQL Server. Using T-SQL: Use master GO sp_configure ‘remote admin connections’, 1  GO RECONFIGURE WITH OVERRIDE  GO Using SQL Server Management Studio:

SSIS Package For Conversion Of Flat File To SQL Server

SSIS Package For Conversion Of Flat File To SQL Server In this tutorial i will explain how to use SSIS Package For Conversion Of Flat File To SQL Server.Or you can say Importing data from a text file to the SQL Server using SSIS(SQL Server Integration Services).In SQL Server 2012 Business Intelligence has been replaced by

How to Use Dedicated Administrator Connection in SQL Server

How to Use Dedicated Administrator Connection in SQL Server In this post we will explain How to Use Dedicated Administrator Connection in SQL Server.Microsoft SQL Server provides a dedicated administrator connection (DAC). The DAC allows an administrator to access a running instance of SQL Server Database Engine to troubleshoot problems on the server—even when the server is

SQL Server Interview Questions & Answers 2

SQL Server Interview Questions & Answers 2 Question 6: How is a point in time recovery performed independent of a server down situation? Ans. It depends on which backup types are issued.  In this example let’s assume that full, differential and transaction log backups are issued. 1. Restore the most recent full backup with the NORECOVERY

SQL Server Interview Questions & Answers

SQL Server Interview Questions & Answers Question 1: How does the database recovery model impact database backups? Ans. Database recovery model is responsible for the retention of the transaction log entries.So the setting determines if transaction log backups need to be issued on a regular or not. SQL Server database recovery models: Simple – Committed transactions