• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
sqlserver tutorial

SQL Server Tutorial

SQL Server Tutorial for Beginners

  • HOME
  • START HERE
  • BASICS
  • ADVANCED
    • SQL Server Index
  • FUNCTIONS

SQL Server Index

This section all about SQL Server Index. Here you will learn everything about indexes in SQL Server like create index, rename index, drop index and more.

Indexes are used to increase the performance of SQL queries. It helps the database engine to retrieve data from tables and views more quickly.

SQL Server Indexes

Indexes are used to increase the performance of SQL queries. It helps the database engine to retrieve data from tables and views more quickly.

This is similar to the index of a book. Whenever you want to search a topic, you refer to the index of the book to find out the page number of the topic to quickly access the topic without checking all the pages of the book.

The index in SQL Server works exactly as same fashion. You can create two types of indexes in SQL Server: cluster index and non-clustered index.

In this section of the tutorial, we will take you through on everything about indexes in SQL Server. So that you can use indexes to optimize your SQL Server query.

  • Clustered Index – Learn what is clustered index in SQL Server and how to create a clustered index.
  • Non-clustered Index – It all about the non-clustered index. This will teach you how to create a non-cluster index in SQL Server.
  • Rename Index – Change the name of the index using T-SQL and SQL Server Management Studio.
  • Disable Index – Learn how to disable index in the SQL Server table.
  • Enable Index – Learn the various methods to enable one or all indexes in SQL Server.
  • Unique Index – This ensures uniqueness value on a certain column(s).
  • Drop Index – Here you will learn how to drop indexes from SQL Server.
  • Index with included column – Tells all about how to add non-key columns to the non-clustered index to improve the speed of the query.
  • Filtered Index – Filter index shows how to create an index on a portion of rows in a table.
  • Index on computed columns – describe function-based index using the index on a computed column.

Primary Sidebar

DATA MANIPULATION

  • SELECT
  • SELECT TOP
  • SELECT DISTINCT
  • OFFSET FETCH
  • ORDER BY
  • GROUP BY
  • BETWEEN
  • LIKE
  • ALIAS
  • HAVING
  • AND
  • OR
  • IN
  • WHERE
  • SELECT INTO
  • INSERT
  • INSERT Multiple rows
  • INSERT INTO SELECT
  • UPDATE
  • DELETE
  • PRIMARY KEY
  • FOREIGN KEY
  • UNIQUE CONSTRAINT
  • NOT NULL CONSTRAINT
  • SUBQUERY
  • CORRELATED SUBQUERY
  • JOINS
  • CROSS JOIN
  • INNER JOIN
  • LEFT JOIN
  • RIGHT JOIN
  • FULL JOIN
  • SELF JOIN
  • UPDATE Join
  • CASE
  • COALESCE
  • NULL
  • NULLIF
  • UNION
  • INTERSECT
  • MERGE
  • EXCEPT
  • EXISTS
  • GROUPING SET
  • PIVOT
  • ROLLUP
  • CUBE

DATA DEFINITION

  • CREATE DATABASE
  • DROP DATABASE
  • CREATE SCHEMA
  • ALTER SCHEMA
  • DROP SCHEMA
  • CREATE TABLE
  • RENAME TABLE
  • DROP TABLE
  • TRUNCATE TABLE
  • IDENTITY column
  • Sequence
  • ALTER TABLE ADD Column
  • ALTER TABLE ALTER Column
  • ALTER TABLE DROP Column

Footer

About

SQLServerTutorial.org provides free tutorials and guide on SQL Server for Developers, Database Administrators, and Solution Architects who want to get started SQL Server quickly.

Recent Posts

  • SQL Server ALTER TABLE DROP Column
  • SQL Server ALTER TABLE ALTER Column
  • SQL Server ALTER TABLE ADD Column
  • SQL Server Index on Computed Columns
  • SQL Server Sequence

Quick Links

  • About
  • Contact Us
  • Privacy Policy
  • SQL Server Index
  • Terms of Use

Copyright © 2021 www.sqlservertutorial.org. All Rights Reserved.