What is Online Index Rebuild Operation?

Answer Posted / saravakumar

Online operation means when online operations are happening
the database are in normal operational condition, the
processes which are participating in online operations does
not require exclusive access to database.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain user defined functions?

606


What is use of except clause?

615


how can you check the level of fragmentation on a table? : Sql server administration

535


How to use "begin ... End" statement structures in ms sql server?

514


What are the differences between union, intersect, and minus operators?

562






What is the purpose of sql profiler in sql server? : sql server database administration

615


Which data type columns are the best candidates for full-text indexing?

590


What are the tools available in market as an alternative to sql server reporting services?

88


Where the sql logs gets stored?

532


What is standby servers? Explain types of standby servers.

503


What language is sql server written in?

523


What is BCNF? How is it better than 2NF & 3NF?

589


What is the difference between grant and with grant while giving permissions to the user?

504


Tell me in brief how sql server enhances scalability of the database system?

513


How does Report Builder support Analysis Services cubes?

110