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.
Write down the differentiation between Power Center and Power Mart?
Illustrates the term data sparsity and how this effect upon aggregation?
Explain the types of jobs we have within the Data stage?
Write down a short note on the functions of a reporting system?
Define the way of passing of variables to a SQL routine.
Explain how one source columns or the rows may be loaded within the two different tables?
Explain the standard folders?
What is Redundant Array of Inexpensive Disks controller technology?
Write about fossils?
Specify the options in the target session of the update strategy transformation?
18,76,764
1933831 Asked
3,689
Active Tutors
1454575
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!