Explain the architecture of SQL Server?

2 Answers   ABC, HP, Oracle,

---

What is a deadlock and what is a live lock?

0 Answers  

---

What are the types of constraints?

1 Answers  

---

Difference between report and query parameter.

0 Answers  

---

If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?

3 Answers  

---

WHAT IS UNIQUE IDENTIFIER DATA TYPE?

2 Answers   Sparsh,

---

sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??

2 Answers  

---

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

3 Answers   HCL,

---

How can I track the changes or identify the latest insert-update-delete from a table?

0 Answers  

---

How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????

3 Answers   SAP Labs,

---

Difference Between varchar and nvarchar datatype?

3 Answers   Satyam,

---

Can we take the full database backup in log shipping?

0 Answers  

---