In this article we will learn how to increase the query performance in SQL Server.

In this article, I will explain how to alter a database table column without dropping the table with simple example.

Performance of data-centric apps heavily rely on the performance of backend API and database. Here are some tops to improve SQL performance.

Explanation And Examples Of Row_Number(), Rank(), Dense_Rank(), Lead(), Lag() SQL Functions

In this article I have described the magic tables and how to use magic tables in SQL Server.

This article provides guidance for the prevention of SQL Injection in your web application and explains how SQL Injection is done.

The purpose of this article is to explain how to keep track of user activities in the Database Managements System.

In this article we'll see how to use the Temporary tables, what are the necessary step to be taken while using them and moreover sometimes it's required to add column in Temporary tables dy...

In this article you will learn how to use SqlDataAdapter Fill Method.

This article explains how to create a RDLC report using VS 2010 and SQL 2008.

Here I am briefly describing the importance and usage of Stored Procedure, followed by its correlation with C#. I also mentioned about ViewState.

Here I show how to find duplicates and their frequency among multiple columns using the GROUP BY clause.

This article shows how to get the months within a date range with SQL Query.

This article will help you to understand the difference between output parameter and return value in a Stored Procedure.

In this article we learn about naming conventions for all objects that are mainly used in SQL.

In this article we will learn about Common Table Expressions (CTE) in SQL SERVER 2008.

In this blog, we will learn how to create a cursor and a temp table. We will also see how to insert data into a temp table.

In this article I am explaining various ways to get the Nth highest salary from an EMPLOYEE table.

This article discusses how to use Joins in SQL Server 2005.

This article answers questions about Auto-incremented ID with the VARCHAR / NVARCAHAR data type in SQL Server.