Answer Posted / gk singh

truncate provide faster processing than delete because of
truncate does'n require transaction log uddation

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

1015

---

What is database architecture? : SQL Server Architecture

976

---

Explain how many normalization forms?

970

---

What are relationships and mention different types of relationships in the dbms

913

---

What is the osql utility?

910

---

You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?

119

---

What is merge replication?

1067

---

Find nth lowest salary or get nth lowest salary?

965

---

What is the use of @@spid?

958

---

How would you go about developing a ssrs report?

159

---

If any stored procedure is encrypted, then can we see its definition in activity monitor?

938

---

Define primary key?

1079

---

How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

1695

---

What is provisioning, billing and metering, and connection routing concepts in the service layer?

113

---

if no size is defined while creating the database, what size will the database have? : Sql server administration

934

---