Avoid Cursor and In when you developing query it reduce the performance when you retrieve the large no of records use inner join to do like in Sql Server .

Here we create a form that executes a parameterized query by allowing user to enter a value into textbox that will be passed to database as the parameter in query.

In this blog we will know how to autoincrement int datatype as well as varchar datatype values in database using stored procedure while inserting records into the tables.

Upgrading the version from Evaluation to Standard/Enterprise/Developer version

This blog discusses the basics of stored procedures and how to create and use them.

How to get the second highest from your table like second highest salary or second highest number.

Difference between Stored Procedure (SP) and User Defined Function

SET or SELECT -- is there any performance difference?

How to use dynamic sql for a nvarchar of more than 4000 characters?

Get the Top Data from SQL Server.

Get the Top Data with Ties from SQL Server (If there are same data….Ties in data will happen. If we need all the data.

Variable in Top Clause (Dynamic value for the top clause):

REBUILDING VS REORGANIZE THE INDEX

Query in one of the forum:

How can we force SQL Server to use a specific index when executing a query?

Query to Create comma separated Output.

In this blog we see, How to Configure CLR integration in SQL Server.

Deleting backup and restore history in MSDB.

Avoiding prefix 'sp_' in the name of user stored procedure in SQL Server

Find the execution time of a stored procedure in SQL Server