SQL Server automatically maintains indexes whenever insert, update, or delete operations are made to the underlying data. These modifications cause the information within the index to become scattered in the database. Fragmentati...
Monday, June 9, 2014
Managing indexes with pre-defined Query: SQL Server
In addition to creating indexes in sql server, database developer also need to maintain them to ensure their continued optimal performance. The common index maintenance tasks include disabling, enabling, renaming, and dropping an...
How to Create Partition Scheme and Clustered Index: SQL Server
After creating the partition function, programmer needs to create a partition scheme to associate it with the partition function. Based on the boundary values defined in the partition function, there will be five partitions. The ...
How to Create Partitioned Indexes in SQL Server
In SQL Server, indexes can also be partitioned based on the value ranges. Similar to the partitioned tables, the partitioned indexes also improve query performance. Partitioning enables you to manage and access subsets of data qu...
Wednesday, June 4, 2014
Types of Secondary XML Indexes in SQL Server
These are non-clustered index of the primary XML index. There must be a primary xml index before each secondary xml index. Following are some types of secondary xml indexes:
Path Indexes
The path index is built on the path value...
Types of XML Indexes used in SQL Server: Speed up Execution
When a query is based on an XML column, the query processor needs to parse the XML data each time the query is executed. In SQL Server, and XML data value can be of a maximum of two gigabytes (GB).
Therefore, the XML values can ...