What are the steps you will take to improve the performance of a poor performing query?

0 Answers  

---

While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

0 Answers  

---

How to start and end transact-sql statements?

0 Answers  

---

What is the cpu pressure?

0 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  

---

any one can explain Self mapping Delegation Remote Credentials

1 Answers  

---

Explain a join?

0 Answers  

---

Explain sp_configure commands, set commands?

3 Answers  

---

What are distributed partitioned views?

0 Answers  

---

What are the different types of backup avaible in SQL SErver

6 Answers   Emphasis, IBM,

---

What are approximate numeric data types in ms sql server?

0 Answers  

---

What is unpivot?

0 Answers  

---