Answer Posted / mohammed

Yes we can

What is the difference between inner join and equi join?

1038

---

which table keeps the locking information? : Sql server administration

1136

---

What is implicit cursors?

1125

---

Describe in brief authentication modes in sql server.

1083

---

What is partitioned view?

958

---

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

1111

---

Explain comment on transactions?

1039

---

What is inline variable assignment?

1077

---

What are the different types of columns types constraints in the sql server?

1124

---

Why can there be only one clustered index and not more than one?

1040

---

How to transfer data from a cursor to variables with a "fetch" statement?

1140

---

but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

1011

---

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

1058

---

Describe in brief sql server monitoring ways.

1095

---

What is amo? : sql server analysis services, ssas

1130

---