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.
Another company used statistic in reports is the total number of orders placed by a shopper. Complete the following steps to create a function named NUM_PURCH_SF that accepts a shopper id and returns the total number of orders the shopper has placed. Use the function in a SELECT statement to display
MiniSQL Parser Relax; you don't have to write the parser! On the contrary, a complete parser and type checker for the MiniSQL language is provided with the skeleton code. This small subset of SQL includes the
Illustrates the applications of ASA?
What are some of the impediments to good decision making? Given the availability of copious information, why do good managers still make bad decision?
Briefly describe the differentiation between data warehouse and OLAP?
Determine the concept of Relation Schema and a Relation?
Illustrates the properties of Cursors in brief?
Explain the designer objects?
Describe a surrogate key and also explain the ideal primary key and illustrate how surrogate keys meet up this ideal?
Write down the level of Granularity of a fact table?
18,76,764
1921769 Asked
3,689
Active Tutors
1429771
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!