Database Tutorials

How to attach a new check constraint from GUI in SQL server

Developers attach a check constraint to a table when they want to specify the data values that are acceptable in one or more columns.When Developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to attach a new check constraint, they should follow the next steps:

1. In …

Learn more

How to delete XML indexes in SQL server

When Developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to delete an XML index, they should follow the next steps:

1. In Object Explorer, right-click the table with the XML index they want to delete and click Design (Modify in SP1 or earlier).

Learn more

How to create an XML index in SQL server

Developers use an XML index to create indexes for columns of the data type xml, which cannot be indexed using the Index/Keys dialog box. Each xml column can have more than one XML index, but the first one created (primary) will be the basis of the others. When Developers working with SQL Server “Denali”, MS SQL …

Learn more

How to specify a fill factor for an index in SQL server

Developers can identify, in Microsoft SQL Server databases, a fill factor to specify how full each index page can be. The fill factor is the percentage of space on each leaf level page to be filled with data, therefore reserving a percentage of free space for future growth. For example, specifying a fill factor value of …

Learn more

How to delete a full-text index in SQL server

When Developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to delete a full-text index, they should follow the next steps:

1. In Object Explorer, right-click the table with the full-text index they want to delete and click Design (Modify in SP1 or earlier).

Learn more

How to delete an index in SQL server

Developers delete an index when they found that the Index hinders overall performance of INSERT, UPDATE, and DELETE clauses or if they no longer need it. When Developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to delete an index, they should follow the next steps:

Learn more

How to rename an index in SQL server

New indexes are automatically given system-defined names based on the database table name. If Developers create multiple indexes on a table, the index names are appended with “_1,” “_2,” etc. They can rename an index as long as index names are unique within the table. When Developers working with SQL Server “Denali”, MS SQL Server 2008 …

Learn more