Interested to Buy Any Domain ? << Click Here >> for more details...
default databases available in sql server and there uses ?
- 4 Answers
- 6920 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / rajesh bhawsar
1.Model
Model database is templete. when u create new database
system gives u a copy of model database
2.Tempdb
Tempdb is scratchpad of sql server
3.msdb
4.master
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Name 3 ways to get an accurate count of the number of records in a table?
What is scan table/view and seek table/view when its occurs? : sql server database administration
Can you explain what are commit and rollback in sql?
What is lookup override?
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
what is the primary use of the model database? : Sql server administration
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
Can foreign key be deleted?
What are various ways to enhance the ssrs report?
What are the differences between decimal and float in ms sql server?
What is the function of sql server agent windows service?
Explain the difference between cross join and full outer join?
What is server-level principal?
