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

What is spid in sql server profiler?

619


What is forward - only cursors / read only cursor?

625


How to return the date part only from a sql server datetime datatype?

674


What are pages and extents? : SQL Server Architecture

643


How do you know if sql server is running on your local system?

628






what is sql server? : Sql server database administration

605


What’s the distinction between dropping a info and taking a info offline?

697


What is the use of builtinadministrators group in sql server? : sql server security

626


How can I create a report based on a query? : sql server management studio

648


Is it possible to call a stored procedure within a stored procedure?

644


Does a sql server 2005 select statement require a from?

694


can we have a nested transaction? : Sql server database administration

588


What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

801


create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

598


If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

757