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 term version Control?
Illustrates the cursors in brief?
What is Data Manipulation Language?
Describe the difference between SQL Server 2000 clustered indexes and non clustered indexes?
What is significance of “ * ” ?
Describe briefly the difference between a Java applet and a Java servlet?
What is meant by the User Objects? Specify some of its restrictions?
Write a brief note on a distributed database?
State some of the sectors where the data warehousing and data mining are utilized.
Explain the difference between heterogeneous and homogeneous distributed database?
18,76,764
1960240 Asked
3,689
Active Tutors
1446788
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!