Computer Science Homework Solutions
Problem
#81560

SQL Server 2000 Database Administration

Discuss your thoughts on the effects of indexes, data types, filegroups, and transaction logs on space considerations. Which of those database constructs do you feel are most important to manage when it comes to database size considerations? Why? What factors would you focus on when determining the actual size of these database constructs? Be sure to cite your sources.

Solution
What is this?
By OTA - Overall OTA Rating
Marcia Wert, MS - 4.1/5
Purchase Cost Now
$2.19 CAD (was ~$3.99)
Included in Download
  • Plain text response
  • Attached file(s):
    • Transaction logs are usually overwritten as soon as a Filegroups.doc
$2.19 Instant Download
Add to Cart
Why you can trust BrainMass.com
  • Your Information is Secure
  • Best Online Academic Help Service
  • Students find real academic Success
Related Solutions
  • Indexes, data types, filegroups, and transaction logs - Discuss your thoughts on the effects of indexes, data types, filegroups, and transaction logs on space considerations. Which of those database constructs do you feel are most important to manage when ...
  • Database Administration - Do all databases need to have an administration capability? Why or why not? If why, what type of activities should be included in database administration?
  • Visual Looping and constructs - You have just been hired to teach a course, not necessarily a programming course, in your local community college. After your first week, you collect the first set of assignments from your students an ...
  • Interesting question - As you review your program, you realize there are various decisions and repetitive actions that need to be made. Some of the decisions involve the determination of the price for the client and whether ...
  • Explain the key concepts that are involved in transaction processing - Explain the key concepts that are involved in transaction processing. Define the concepts and provide an explanation of the commands that are involved in the transaction. Also, explain the advantage ...
Browse