SQL Server provides two types of indexes, clustered and non-clustered indexes. Here you will learn non-clustered indexes. The non-clustered index does not sort the data rows physically.

As mentioned before, a table without indexes will be stored in an unordered structure. When you define a clustered index on a column, it will sort data based on that column values and store it.

Learn how to modify or delete existing indexes using T-SQL and SQL Server Management Studio.

Learn SQL step-by-step using practical examples. These SQL tutorials covers all the aspect of query language to manipulate and retrieve the data from the relational databases.

If clustered or nonclustered is not specified, then a unique clustered index for the primary key column will be created if there no clustered index on the table.

In SQL Server, the sequence is a schema-bound object that generates a sequence of numbers either in ascending or descending order in a defined interval. It can be configured to restart …

Functions in SQL Server contains SQL statements that perform some specific tasks. Functions can have input parameters and must return a single value or multiple records. If your scripts …

You can modify the primary key of a table by changing the key name, columns order, clustered option, or fill factor. To modify a primary key using T-SQL, you must first delete the existing …

In SQL Server, the synonym is the database object that provides alternate name (alias) to another database objects such as table, view, stored procedure, etc. in the local server or a remote …

Learn about Triggers in SQL Server. The trigger is a database object similar to a stored procedure that is executed automatically when an event occurs in a database.