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

SQL Server Tables

Create a SQL Server table

How to create a SQL Server table with a simple query? This basic SQL example creates a table to store Sales data. It is using different data types, such as strings, numeric values, decimal

SQL Server management studio

Option to check object existence in scripts

How to add or remove the object existence checks in SQL creation scripts with SQL Server Management Studio? To add dynamically the existence check before generating the create statement for you SQL Objects like tables,