What is a unique index?

0 Answers  

---

How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?

1 Answers  

---

Describe how to use linked server?

0 Answers  

---

What is row_number () and partition by in sql server?

0 Answers  

---

What is a view and what are its advantages?

0 Answers  

---

---

What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

0 Answers  

---

What is the need for group functions in sql?

0 Answers  

---

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

0 Answers  

---

What is the default schema of your login session in ms sql server?

0 Answers  

---

How can i Relate Tables in SSIS

0 Answers   HCL,

---

Detail about query optimizer?

0 Answers  

---

What is the recommended total size of your memory optimized tables?

0 Answers  

---