what is ONLINE INDEX?

Add comment

Votes: 0

Comments: 44

Online Index is a feature available after SQL Server 2005, prevously DBAs had to build index during off-peak hours as SQL Server locks data for exlusivly during building of index .

using Online Index the index operations on the underlying table can be performed concurrently with update or query operations. This was not possible in previous versions of SQL Server.

This functionality only avialble in Enterprise Edition of SQL Server 2005

Showing: 1-20 of 44 »»

Comments

31 Dec, 1969 | Guest

sql select unique

31 Dec, 1969 | Guest

hosting ms sql

31 Dec, 1969 | Guest

compare dbms

31 Dec, 1969 | Guest

online database application

31 Dec, 1969 | Guest

dbms packages

31 Dec, 1969 | Guest

cloud dbms

31 Dec, 1969 | Guest

database types

31 Dec, 1969 | Guest

free sql training

31 Dec, 1969 | Guest

sql backup software

31 Dec, 1969 | Guest

database concepts

31 Dec, 1969 | Guest

dbms

31 Dec, 1969 | Guest

music database

31 Dec, 1969 | Guest

columnar dbms

31 Dec, 1969 | Guest

sql join statement

31 Dec, 1969 | Guest

sql server round

31 Dec, 1969 | Guest

cosmetic database

31 Dec, 1969 | Guest

sql classes

31 Dec, 1969 | Guest

data management systems

31 Dec, 1969 | Guest

dbms

31 Dec, 1969 | Guest

free sql training

Showing: 1-20 of 44 »»

Add comment

Others in this Category

	What is Data Mapping
	What is an Ad Hoc Query?
	what is the method to change location of tempdb?
	How to know which index a table is using?
	Which Stored procedure will be used to create an alert in database?
	which clause specified while creating a stored procedure causes the stored procedure to recomplile every time it is run?
	Which stored procedure is used to change the password for the distributor?

Name:
Email:
* Comment: (Use BBcode - No HTML)

* Confirmation code:	Write the characters in the image above exactly as you see it