blank
SQL Server Index

How to create a SQL Server index?

Create a SQL Server index to improve the performance of queries on tables and clustered views. Two types of index exists, the clustered and the nonclustered one. To create a nonclustered index, use this

blank
SQL Server Index

How to rebuild a SQL Server index?

Maintain the indexes is vital to keep a database up to speed with optimal performance. To rebuild an index, use the command to alter and rebuild. Technically speaking, the query rebuilding the index delete

blank
SQL Server stored procedure

Alter a SQL Server stored procedure

How to alter an existing stored procedure in a SQL Server database? Simply use the alter command instead of the create command one to modify an existing SQL procedure. In this example let’s add