What do you mean by an execution plan? Why is it used? How would you view it?

0 Answers  

---

how to improve the speed of SQL database server and how to avoid dead lock?

1 Answers   TCS,

---

What is page in sql server?

0 Answers  

---

What is the difference between rank and dense_rank?

0 Answers  

---

How to reaname table name without using sp_Rename in sql server..?

0 Answers   Wipro,

---

Hi..here i would like to know the Backup and Restore models?

2 Answers   HCL,

---

Difference between uniqe index and uniqe constraint?

0 Answers  

---

What are the types of subscriptions in SQL Server replication?

0 Answers   HCL,

---

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

0 Answers  

---

What happens when unicode strings concatenate with non-unicode strings?

0 Answers  

---

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  

---

Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???

3 Answers  

---