Answer Posted / madhuparna

select top 1 * from (select top 2 * from employee)A

What is inner join? Explain with an example?

1279

---

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

996

---

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

931

---

List the advantages of using stored procedures?

1106

---

Explain the purpose of indexes?

1016

---

What is a fill factor?

1137

---

What happens if null values are involved in datetime operations?

1021

---

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

1034

---

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1104

---

List the different types of collation sensitivities in sql server?

1074

---

What are dml triggers and types of dml triggers?

1028

---

Explain different types of Normalization.

1897

---

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

1097

---

Difference between connected and disconnected database in .net with sql server?

1146

---

What is provisioning, billing and metering, and connection routing concepts in the service layer?

115

---