Explain an unsupported method to shrink a database
Explain an unsupported method to shrink a database.
Expert
To shrink a database an unsupported method describe below:This process is quite trivial in some cases, like removing a recently added fragment or trimming a database which has a log fragment like its final allocation, although, can also be much more difficult or time consuming than the bcp and script method.
Common Outline
The common outline of how to do this is:1. Make a backup of the present database2. Migrate data by sysusages fragments along with high lstart values to fragments along with low lstart values.3. Then edit sysusages to eliminate high lstart fragments which no longer have data allocations.4. Reboot the ASE.
Briefly explain continuous and discrete data in data mining?
Illustrates the term update statistics in Sybase?
Explain what is Designer?
Differentiates Tuple-oriented relational calculus and domain-oriented relational calculus?
Give us a non-computer illustration of preemptive and also non-preemptive scheduling?
Differentiate between Multiload and Fastload in terms of Performance?
What is the simplest sorting method to utilize in data structures?
Explain the term local container and shared container?
Why we use Context? And explain the LOV?
Specify the difference between the ER Modeling and Dimensional Modeling?
18,76,764
1933200 Asked
3,689
Active Tutors
1454629
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!