Books and articles about SQL Rambler's Top100 Сменить язык на: Русский 19 March 2024 12:34:57


www.sql-ex.ru
Skip Navigation Links  

 

MS SQL Server 2005 (part 2)


AuthorIvan Bodjagin
Title

MS SQL 2005: window functions

Annotation There are two types of analytical functions in MS SQL Server 2005 –aggregate and ranking functions.

Authordecipherinfosys
Title

Moving table(s) to a different filegroup in SQL 2005

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.

AuthorTim Chapman
Title

Detecting index fragmentation in SQL Server 2005

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.


Usage of any materials of this site is possible
only under condition of mandatory allocation of the direct link to a site
http://www.sqlbooks.ru
on each page where used materials are placed.

 Main   Articles    Books 
Рейтинг@Mail.ru Rambler's Top100 Alt Упражнения по SQL: обучение, тестирование, сертификация по языку SQL Copyright c 2002-2006. All rights reserved.