Sql Server 2005 Index

[sendba]

Hi all

Does anyone know how Online index rebuilding works.

My question is :
Whether the index is rebuilt using Indexdefrag or can it be dropped and recreated.
Please help and also have anyone configured SQL Server 2005 Notification services, if so please let me know how to configure it.

Thanks in advance

Sen

 

[mrdenny]

I'm not quite sure how to answer your question.

First an indexdefrag isn't a rebuild.

When a rebuild of the index is done SQL does a dirty read of the table, keeping track of all changes to the table during that dirty read. Then the data from the dirty read is put into the index, and then the changes are applied. The index is then made available.

You can either rebuild an index or create a new index with the online flag set on.

I've looked into notification services a little bit, but got bored with it quickly.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com