Answer Posted / rajesh s. chandan

It depends of Microsoft SQLm Server version.
When we install Microsoft SQL Server 2008 then SQL Server
installer will install following database.
System databases
1.master
2.model
3.msdb
4.tempdb
If we configure replication then it will create
distribution database.

When we install Reporting Services (SSRS) , then it will
install ReportServer and ReportServerTempDB. We could also
install sample databases like AdventureWorks and
AdventureWorksDW.

Whenever, we restart the SQL Server, it will freshly create
tempdb database. Hope this information will help you.

What is a with(nolock)?

978

---

What security features are available for stored procedure?

1025

---

What is the filtered index?

1039

---

How to view existing indexes on an given table using sp_help?

1121

---

What is the new security features added in sql server 2016? : sql server security

1097

---

What is difference between inner join and full join?

1053

---

Where do you find the default Index fill factor and how to change it?

1052

---

How to provide login information for a new odbc dsn?

1044

---

How to find which stored procedure is currently running in sql server?

976

---

Is port 1433 secure?

989

---

what are defaults? : Sql server database administration

1077

---

Would you store your query in a ssrs report or a database server? State the reason why?

152

---

What happens if the update subquery returns no rows in ms sql server?

1113

---

What are the functions in sql server?

940

---

What is the difference between lock, block and deadlock? : sql server database administration

1032

---