Answer Posted / hari

Constraint : To Restrict the voilation of irrelegular data
and maintain data integrity.

Primary key
Unique Key
NotNull
Forigen Key
Check

How to truncate the log in sql server 2012? : sql server database administration

1289

---

How many levels of sp nesting are possible?

1026

---

what is denormalization and when would you go for it? : Sql server database administration

1188

---

Name and describe few console utilities for ssrs?

284

---

Explain syntax for viewing, dropping and disabling triggers?

953

---

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

3873

---

What is left outer join in sql server joins?

1041

---

Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

145

---

Explain sql server service broker?

977

---

What is isnull() operator?

1037

---

role of sql sever 2005 in database rather than any other database

1940

---

What is nolock hint in sql server 2008

1127

---

What are different backups available in sql server?

1072

---

What do you understand by recursive stored procedures?

988

---

What stored procedure would you use to view lock information?

975

---