Year: 2013

Overview We are using the [INFORMATION_SCHEMA]. [COLUMNS] view to get the information about a column and its associated tables available…

Background: The purpose of this article is to provide a simple way of getting a list of all the concurrently…

/*Starting loop to lock the table for sometime*/ USE YourDatabase_Name GO DECLARE @ID INT SET @ID = 1 WHILE @ID…

/* Table Schema*/ CREATE TABLE [dbo].[SalesData](       [FiscalYear] [float] NULL,       [SalesRegion] [nvarchar](255) NULL,       [SalesAmount] [float] NULL ) ON…

1.      Background The purpose of this article is to describe how to reset the identity column of a table in…

SELECT name AS Table_Name_WithoutClusteredIndex  FROM SYS.TABLES WHERE OBJECTPROPERTY(OBJECT_ID,‘TableHasClustIndex’) = 0 ORDER BY NAME GO    

CREATE ASSEMBLY uploads an assembly from  .dll file to use inside an instance of SQL Server. Below is the code…

Xp_cmdshell is an extended stored procedure that provides an environment analogous to a Windows command shell and passes in a…

Approach: Sys.objects table contains information about all the objects of a database We are filtering the trigger objects with TYPE…