Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ramesh
ALTER INDEX <Index> REBUILD ONLINE;
one Should Configure a script to Rebuild indexes at Regular
intervals for the needy
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
Can you redefine a table online?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
How do you open a cluster administrator? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
Why would you call update statistics? : sql server DBA
What is dcl? : sql server DBA
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
What is transparent data encryption? : sql server DBA
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
what is the use of ocr?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What are the commands used in dcl? : sql server DBA
