Month: August 2013

1.     Background The purpose of this article is to describe an efficient way of getting the row count of the…

1.     Background The purpose of this article is to describe how to generate Fibonacci series in SQL Server. As per…

1.     Background The purpose of this article is providing a way of managing duplicate string data in such a case…

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…