Answer Posted / sairam

select datename(mm,getdate())

between cast and convert which function would you prefer and why?

528

---

Explain how you can deploy an SSRS report?

106

---

Differentiate between sql temp table vs table variable?

510

---

What are subqueries in sql server?

589

---

Explain about Views?

597

---

---

Describe how to use the linked server?

591

---

Explain “not null constraint” in sql server?

518

---

What is rolap and its advantage? : sql server analysis services, ssas

639

---

How to create sub reports?

192

---

Define compound operators?

529

---

What is the difference between grant and with grant while giving permissions to the user?

504

---

What is sql server transaction log file?

514

---

Explain what is lock escalation and what is its purpose?

509

---

Explain Capacity planning to create a database? and how to monitor it?

3746

---

How to update values in a table with update statements in ms sql server?

549

---