This blog presents tips to increase SQL Server stored procedure performance by using SET NOCOUNT ON, schema name before objects, EXISTS () instead of COUNT (), NO LOCK, Join query, avoid Select *, ...

This blog helps to understand how we can do MS-SQL to JD Edwards date conversion.

Case statement is mostly used in Real Time scenarios

This article emphasizes that there is no need to delete a whole table. Instead, write SQL query to get this result.

UNPIVOT operator is the reverse process of PIVOT operator.

Temporary tables are created in TempDB database and are automatically deleted, when they are no longer used.

Pivot is an operator in SQL Server.

This blog illustrates SET NOCOUNT ON and SET NOCOUNT OFF, which are very useful in real time scenarios inside stored procedure in SQL Server.

INSTEAD OF UPDATE TRIGGERS correctly update a view.

INSTEAD OF DELETE TRIGGERS are used, to delete records from a view.

In this blog, we will learn about NULL value in SQL Server.

This blog acquaints you with deleting duplicate records from a table in SQL Server, using ROW_NUMBER.

INSTEAD OF triggers are usually used to correctly update views that are based on multiple tables.

In this blog, we will see how to fetch common records from two tables in SQL Server, which means the matching records of both the tables will be shown.

In this blog, we will calculate occurrence of a particular character in the string.

In this blog, we will print 1 to 100 numbers in SQL Server without using while loop.

This blog helps you to get the status about inserted records in the respective table by the user in your database.

The trigger will be fired when the host in SQL Server will update any data.

The records deleted what Date Time and the Host Name can be identified.

This blog helps in providing permissions, which refer to the rules governing the levels of access.