Answer / Umesh Kumar Yadav

{"answers": ["Inner Join", "Left Join", "Right Join", "Full Outer Join", "Cross Join"]}

What is blocking and how would you troubleshoot it?

2 Answers  

---

Why should we go for stored procedures? Why not direct queries?

1 Answers  

---

What gets stored inside msdb database?

1 Answers   Abacus,

---

What is Files and Filegroups in SQL Server & it's implementation.

1 Answers   Zenith,

---

How to create nested stored procedure?

1 Answers  

---

Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?

3 Answers   IBM, L&T,

---

What are the pre-defined functions in the sql server?

1 Answers  

---

What is hot add cpu in sql server 2008?

1 Answers  

---

How to use “drop” keyword in sql server and give an example?

1 Answers  

---

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

1 Answers  

---

Explain an incremental backup?

1 Answers  

---

can a database be shrunk with users active? : Sql server administration

1 Answers  

---