SQL Server Tutorial

Learning Objective

The objective of this SQL Server tutorial is to teach you what is a filtered index, its benefits, and how to create one on a table.

What is SQL Server Filtered Index?

A filtered index is new type of index which was introduced in SQL Server from SQL Server 2008.… Read More »

Learning Objective

The objective of this SQL Server tutorial is to teach you how to rename an index associated with a table or view.

Introduction to SQL Server Rename Index

Renaming an index changes the name of an index and gives it the new name.… Read More »

Learning Objective

The objective of this SQL Server tutorial is to teach you what is a unique index and how to create it on a table or view.

Introduction to SQL Server Unique Index

A unique index is an index with a unique key.… Read More »

Learning Objective

The objective of this SQL Server tutorial is to teach you how to disable an index associated with a table or view.

Why Disable?

An index is a disabled in one of the following scenarios.

1. To check the performance of an index – An index is oftentimes disabled to check query performance without the index so as to figure out whether the index is having a beneficial effect or whether we can do without the index.

… Read More »

Learning Objective

The objective of this SQL Server tutorial is to teach you how to enable a disabled index associated with a table or view.

Introduction to SQL Server Enable Index

An index is often disabled during bulk updates or to check the performance of the queries on the table without the index so as to determine its efficacy and need.… Read More »

Learning Objective

The objective of this SQL Server tutorial is to teach you how to remove an index from a table or view.

Introduction to SQL Server DROP INDEX

What is an INDEX?

An index is a list of items ordered alphabetically or on some other ordering criteria so that the items and the information about the items can be accessed easily and quickly.… Read More »