Explain the properties of a relational table?

0 Answers  

---

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

0 Answers  

---

You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

0 Answers  

---

Do you know how to make remote connection in database?

0 Answers  

---

Difference between server.transfer and server.execute method?

2 Answers  

---

---

what is isolation level at dead lock?

0 Answers   Verizon,

---

Explain query editor regions

0 Answers  

---

What is the maximum size of a dimension? : sql server analysis services, ssas

0 Answers  

---

What is 2nf in normalization?

0 Answers  

---

Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp where (salery >=emp.salery) Enter n value 2 These query is correct or not. Tell me any other methods.

6 Answers  

---

Is truncate autocommit?

0 Answers  

---

What are the differences between stored procedure and the dynamic sql?

0 Answers  

---