Interested to Buy Any Domain ? << Click Here >> for more details...
Explain what partitioning is and what its benefit is.
- 2 Answers
- 7328 Views
- I also Faced
- E-Mail Answers
Answer Posted / ramesh
And the Advantage are
1.Maintaincace :-Can Take Partioned tables's tablespace
offline for recovery
while other partitions are still avialable to users
Hence the Avialability
2.Performace :As the Objects are plcaed in Diffrent
Tablespaces of Diffrent Servers/locations
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what are the types of connection load-balancing?
What is the difference between clustered and non-clustered index? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What types of replication are supported in sql server? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?
What is fill factor? : sql server DBA
Why would you use sql agent? : sql server DBA
how can you schedule a job in database?
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? : sql server DBA
how can you initialize log miner?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What the different topologies in which replication can be configured? : sql server DBA
Can you redefine a table online?
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?
