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 …
How to check existing data when creating a check constraint in SQL server
Developers can create a check constraint, by setting an option to apply it either to new data only or to existing data as well. The first option is useful when they know that the existing data already meets the new check constraint, or when a business rule requires the constraint to be enforced only from this …
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).
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 …
How to show index properties in the Properties window in SQL server
When Developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to view index properties, they should follow the next steps:
1. In Object Explorer, right-click the table for the index with properties they want to see and click Design (Modify in SP1 or earlier).
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 …
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).
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:
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 …
How to disable a foreign key constraint for INSERT and UPDATE statements from GUI in SQL server
Developers select and use the option to disable a foreign key constraint during INSERT and UPDATE transactions if they know that new data will violate the constraint or if the constraint applies only to the data already in the database. Developer can disable a foreign key constraint for INSERT and UPDATE statements, by following the next …