This article describes how to enable FILESTREAM by using SQL Server Configuration Manager.

In this article, you will see some of the SQL Server Error functions which provide information about the error.

In this article, I described how to use the TEXTPTR Function in SQL Server.

In this article, I would like to show the functions Month and Eomonth in SQL Server.

In this article i have explained detailed about the Sub-Queries in sql Server

Deletion of duplicate records from a table is tricky and can be done in various ways. One simple approach can be applied as described in this article using a Group By and sub-query.

In this article I described the Case Statement in SQL Server.

In this article I describe how to drop all the Views in a particular database

In this article, I will explain the use of the TOP WITH TIES Clause in SQL Server.

This article will give you an idea of how to use the Output clause and also defines where you can use it.

In this article I described the Magic Table in SQL Server.

In this article I describe Union Operator, Union all Operator and difference between union and union all operator.

In this article, I would like to show the DATEDIFF function in SQL Server.

In this article I described @@Fetch_Status in SQL Server 2012.

In this article, we will see how to modify the data of an underlying base table in SQL Server using a View.

In this article I described the Identity function in SQL Server.

In this article, I described how to use the ReadText and WriteText statements in SQL Server.

In this article, I would like to show the new built-in function Lead in SQL Server.

In this article, I would like to show the new analytic functions First_Value and Last_Value in SQL Server.

This article will give you an idea of how to use the space function in SQL Server.