Differences between Standby Vs No recovery?

2 Answers   Wipro,

---

Define tempdb database?

0 Answers  

---

What is stored procedures?

0 Answers  

---

Scalability, Availability, Integration with internet, etc.)?

0 Answers  

---

What is a transact-sql statement?

0 Answers  

---

---

Give me any three differences between Truncate and Delete.

0 Answers   Genpact,

---

If suppose in a table ship(name,year),find ship name having first and last name(i.e having space in between) ex: SAINT LOUIS,JET LAKE.

4 Answers  

---

What is sql server database?

0 Answers  

---

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

4 Answers   Credit Suisse, GCU, Symphony, TCS,

---

What is scd (slowly changing dimension)? : sql server analysis services, ssas

0 Answers  

---

How do you measure the performance of a stored procedure?

3 Answers   Infosys,

---

When I delete any data from a table, does the sql server reduce the size of that table?

0 Answers  

---