Which databases are part of SQL server default installation?
Explain the usage of each?
Answers were Sorted based on User's Feedback
Answer / guest
4 key default dbs :-
Master db : Holds info of all dbs located on SQL Server
insytance. Main db (else SQL Server won't work !)
MSdb : Stores info regarding Backups, SQL Agent info, DTS
packages, SQL Server jobs, replication info for log
Tempdb : To hold temp objects like global & local temp
Model db: Used in creation of any new database within the
SQL Server instance of which it(model) is a part.
|Is This Answer Correct ?||6 Yes||1 No|
Answer / hari
In 2005 .newly implemented Resource Db
|Is This Answer Correct ?||3 Yes||2 No|
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
How to divide query output into multiple groups with the group by clause in ms sql server?
What is resultset concur_updatable?
What are scalar functions?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
Explain what are various ways to enhance the ssrs report?
How is a full-text index updated?
What are the advantages of using views. Why do we need views when we have SPs?
What stored procedure can you use to display the current processes?
How to query multiple tables jointly?
What is the difference between SSAS 2000 and SSAS 2005?
What are a scheduled jobs or what is a scheduled tasks?