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…