What is the difference between char and varchar2 datatype in sql?

0 Answers  

---

How to view the error log for any specific instance? : sql server database administration

0 Answers  

---

How to create nested stored procedure?

0 Answers  

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

Explain what is lock escalation?

0 Answers  

---

---

Please tell me some knowledge about Clustering and how to add clustering?

1 Answers  

---

What is awe?

0 Answers  

---

if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition

1 Answers   Aviva,

---

Explain tablesample?

0 Answers  

---

Can we insert data if clustered index is disabled?

0 Answers  

---

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

0 Answers  

---

What is referential integrity and how is it achieved?

1 Answers   Adea Solutions,

---