Explain the way to shrink a Database
Explain the way to shrink a Database?
Expert
This has historically been difficult to shrink any database except tempdb (since it is created fresh each boot time). The two ways commonly used have been:
1. Make sure that you have scripts for all your objects (several tools like SA Companion, dbschema.pl or DB Artisan from Sybperl can create scripts by an existing database), then bcp out your data, drop that database, recreate this smaller and run your scripts, as well as bcp in your data.
2. Utilize a third-party tool such as DataTool's SQL Backtrack, that in essence automates the first process.This technote draws a third possibility which can work in most cases.
Homework E-R Modeling Follow a MOVIE database where data is recorded about the movie industry. The data needs are summarized as follows: _ Each and every movie is identified by title & year
Which efficient data structure is used in RDBMS, for internal storage representation?
Explain the way to unzip a File in SSIS.
Evolution of Cloud Computing: Cloud computing refers to the technology which enables each and every functionality of Information Technology which may range from IT platform to IT solutions to be broadcasted as a set of services uninterruptedly so that
Give a brief introduction of the term active data warehousing?
Give a brief introduction of the term SAS Business Intelligence?
What does web mining mean
What is Relational Algebra?
What are a Database system and its advantages?
What are the Features of Monopoly?
18,76,764
1928465 Asked
3,689
Active Tutors
1420453
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!