What is Clustering?A Microsoft SQL Server Cluster is nothing more than a collection of two or more physical servers with identical access to shared storage that provides the disk resources required to

Use this script in order to backup a database :/*Author : Suprotim AgarwalCreation Date: Jan 2, 2008*/CREATE PROCEDURE [dbo].[usersp_BackUpDB]@DBNAME nvarchar(50),@PATH nvarchar(200),@BCKUPNAME nvarc

At times, we need to check the number of active connections for each Database on our server. This can be done easily using the following script. The script displays the DatabaseName, the number of co

Sql Server Reporting Services provides a few global collections that you can use in your reports to retrieve report information. One such collection is GlobalsGlobals contains global variables which

You can use Bulk Insert or SSIS to import text/csv files. There are some advantages and disadvantages using any of these methods. In this article, we will explore how to use the OPENROWSET to read a d