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.

Is foreign key a primary key?

677

---

what's the maximum size of a row? : Sql server database administration

733

---

What is constraints and its types?

675

---

Difference between primary key and clustered index?

680

---

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

1714

---

---

How to defragment table indexes?

697

---

What does it mean to normalize data?

662

---

How to skip remaining statements in a loop block using continue statements?

738

---

How to find out the list schema name and table name for the database?

704

---

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

684

---

Explain what is the function of sql server agent windows service?

701

---

How to update multiple rows with one update statement in ms sql server?

847

---

Define full outer join?

696

---

Explain relational data?

695

---

What is the difference between grant and with grant while giving permissions to the user?

724

---