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.
Explain the way to unzip a File in SSIS.
Illustrate why informational and operational systems are separate?
What is meant by the Cardinality?What is meant by the Cardinality?
Write down the level of Granularity of a fact table?
Elucidate how can we get first 100 rows from flat file in the target?
Give a brief introduction of the term real time data-warehousing?
Illustrates the term Monopolistic Competition?
Describe how we can add a NOT NULL column to a table?
Specify the various methods through which we may link the universes?
Illustrates the term tkprof and how is this used?
18,76,764
1929942 Asked
3,689
Active Tutors
1448847
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!