|
Author | Ivan Bodjagin |
Title |
|
Annotation |
There are two types of analytical functions in MS SQL Server 2005 –aggregate and ranking functions.
|
|
Author | decipherinfosys |
Title |
|
Annotation |
In SQL Server 2005, a new clause ‘MOVE TO’ was added to the ALTER TABLE command to allow for moving a table to a different filegroup.
|
|
Author | Tim Chapman |
Title |
|
Annotation |
When data is inserted, updated, or deleted in a database table, if indexes exist that operate on the table, they must be maintained to reflect the table data changes. The maintenance of these indexes will eventually cause the indexes to become less efficient. This inefficiency is typically due to the index becoming fragmented.
|