Explain features of analysis services?

0 Answers  

---

How to provide default values to function parameters?

0 Answers  

---

In which tcp/ip port does sql server run? Can it be changed?

0 Answers  

---

What is explicit cursors?

0 Answers  

---

what are the different types of replication you can set up in sql server? : Sql server database administration

0 Answers  

---

---

What guidelines should be followed to help minimize deadlocks?

0 Answers  

---

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

0 Answers  

---

How to insert data into an existing table?

0 Answers  

---

What is the difference between UNIQUE and DISTINCT keywords in DBMS?

1 Answers   Genpact,

---

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

0 Answers   Facebook,

---

Tell me what is sql profiler?

0 Answers  

---

Explain about protocol layer present in SQL server?

0 Answers  

---