T-SQL script to get user information that has locked table
/*Starting loop to lock the table for sometime*/ USE YourDatabase_Name GO DECLARE @ID INT SET @ID = 1 WHILE @ID…
Year: 2013
T-SQL script to delete the duplicate records in the table
/* Table Schema*/ CREATE TABLE [dbo].[SalesData]( [FiscalYear] [float] NULL, [SalesRegion] [nvarchar](255) NULL, [SalesAmount] [float] NULL ) ON…
How to reset Identity column in SQL Server
1. Background The purpose of this article is to describe how to reset the identity column of a table in…
T-SQL script to get list of tables which dont have clustered index
SELECT name AS Table_Name_WithoutClusteredIndex FROM SYS.TABLES WHERE OBJECTPROPERTY(OBJECT_ID,‘TableHasClustIndex’) = 0 ORDER BY NAME GO
SQL Server – How to create an assembly in SQL Server that references a .DLL file
CREATE ASSEMBLY uploads an assembly from .dll file to use inside an instance of SQL Server. Below is the code…
How to enable xp_cmdshell in SQL Server
Xp_cmdshell is an extended stored procedure that provides an environment analogous to a Windows command shell and passes in a…
T-SQL script to get list of all the tables having triggers in a database with trigger name.
Approach: Sys.objects table contains information about all the objects of a database We are filtering the trigger objects with TYPE…
SSAS – XMLA script to restore the Analysis database
This script provides an easier way of restoring the analysis DB and it is useful when replica or snapshot of…
SSAS – XMLA script to Backup Analysis Database
This XMLA script that supports SQL Server Analysis Service is used to take the backup of Analysis database. Change the…
SSRS – How to add custom message in report when there is no data available
1. Background The purpose of this document is to describe a way of showing custom message in the report if…
How to process OLAP Cube using SQL Server Agent Job
1. Background The purpose of this document is to describe a way of processing OLAP cube using SQL Server Agent…
How to create Connection String using Notepad
1. Background The purpose of this document is to describe how to create connection string for OLE DB provider and…