In this article we will learn why functions should be avoided on indexed columns in where clauses of select statements.

This article explains how to create a Stored Procedure in SQL that accepts a data table as parameter.

This article shows how to pass a collection of records to a database for processing. In SQL Server 2008 we make a custom data type TABLE to pass a collection of rows to a Stored Procedure.

This article describes how to allow users to build a database automatically from an application via two technologies, code generation (CodeDOM) and NHibernate (Fluent) that let us make a backend re...

In this article you will learn how to identify unused Indexes in a SQL Server database.

In this article we will see the impact of sp_prefix on Stored Procedure performance.

In this article you will learn how to rebuild a master database in SQL Server.

In this article you will learn about the joins in SQL.

In this article we will learn how to pass table type data to a SQL object.

In this article we learn SQL from the basics. Here I describe all the basic terminology of SQL.

This article explains the magic (Virtual) tables in SQL.

This is a small SQL Code snippet for splitting string lists into a table based on one or more delimiters.

In this article we will learn how to create a Clustered Index for other than a primary key column in SQL server.

This article explains some of the most commonly used string functions in SQL Server.

This article provides a solution to SQL Server: A (0-1 & 1-0) conversion puzzle.

In this article you will learn about SQL Server Exception Handling.

In this article you will learn about User Defined Types (UDTs) in Microsoft SQL Server.

In this article you will learn Localization in SSRS Reports.

In this article you will learn about the Union and Union All commands in SQL Server.

This article shows how to remove duplicate records from a SQL Server table.