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
What are the steps you will take to improve performance of a poor performing query?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
Explain about your sql server dba experience? : sql server DBA
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
What is the difference between dropping a database and taking a database offline? : sql server DBA
what is asm?
how can you create a user-defined lock?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
what is the role of dip user in our database?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
What the different topologies in which replication can be configured? : sql server DBA
