Answer Posted / guest

SQL SERVER - is for running the databases SQL AGENT - is for
automation such as Jobs, DB Maintanance, Backups DTC - Is
for linking and connecting to other SQL Servers

How many primary keys are possible in a table?

966

---

Can you leave a union at any time?

1106

---

Explain about service Broker functions?

1089

---

Does an index slow down updates on indexed columns?

1035

---

How to create a stored procedure with a statement block in ms sql server?

1129

---

What happens if you add a new index to large table?

982

---

Where sql server usernames and passwords are stored in a sql server?

1037

---

What is the report builder?

143

---

How do you implement session management in SQL Server mode?

1156

---

Can I use sql azure as a backup with log shipping or database mirroring?

156

---

What do you do in data exploration

1050

---

How can we determine what objects a user-defined function depends upon?

1075

---

What is the difference between varchar and varchar types?

1121

---

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

947

---

Explain the steps to create and execute a user-defined function in the sql server?

1016

---